Number of matched values

[wdbouk]

Hi all,

I will start with an example:

I have a column A consisting of ID numbers . I want to count the number of times each ID number is mentioned.
For example

ID

ABC
ABC
XYZ
a123
a123
a123
then ABC should =2,XYZ=1,a123=3.
Any help of how to do it?
thx

 

[Golom]

Try this

Select ID, Count(*) As [NumberOfIDs]

From tbl

GROUP BY ID

 

[wdbouk]

It works
thx