ASP Group Same Records and Give Total Count

[gotcha]

I need to know how to group like parts, then count them in asp. I
have a table with 60,000 + part numbers that I need a total of each
one that is the same. For example.

Table:
000000-cpq
000000-cpq
199888-001
199888-001
244166-001

Results:
000000-cpq = 2
199888-001 = 2
244166-001 = 1

Thanks for any help in advance. [email]gil@ambry.com[/email]

[Aaron [SQL Server MVP]]

Assuming [some column name] does not allow nulls:

SELECT [some column name], COUNT([some column name])
FROM [some table name]
GROUP BY [some column name]

--
[url]http://www.aspfaq.com/[/url]
(Reverse address to reply.)




"gotcha" <gil@ambry.com> wrote in message
news:73a4f99a.0408061146.156487dd@posting.google.c om...

> I need to know how to group like parts, then count them in asp. I
> have a table with 60,000 + part numbers that I need a total of each
> one that is the same. For example.
>
> Table:
> 000000-cpq
> 000000-cpq
> 199888-001
> 199888-001
> 244166-001
>
> Results:
> 000000-cpq = 2
> 199888-001 = 2
> 244166-001 = 1
>
> Thanks for any help in advance. [email]gil@ambry.com[/email]