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" <gilambry.com> wrote in message
news:73a4f99a.0408061146.156487ddposting.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]gilambry.com[/email]
Bookmarks