conditions for the query

[ryan]

My question deals with duplicate queries. I have duplicates that resulted
from a query and I want to know the number of duplicates or if I can number
the duplicates with the same number.

For example:

Number ID
1 4433
1 4433
2 8733
2 8733
2 8733
3 9121
3 9121


If anyone has some suggestions it would be greatly appreciated

 

[KARL DEWEY]

SELECT YOURTABLE.ID, Count(YOURTABLE.ID) AS [How many]
FROM YOURTABLE
GROUP BY YOURTABLE.ID;