[SOLVED] Counting Largest number of ID's??????

[budimir]

I need help!

 

I have and ID field in a table and loads of information in it. I would like to count and display numbers of ID's in the column.

 

So, basiclly, this is what I'd like to get:

 

ID 54 = 13 times in table

ID 16 = 55 times in table

ID 78 = 100 times in table

 

I hope you get ehat I mean.

 

I NEED THIS, PLEASE HELP!!!!!

[toplay]

Try something like the following query. It assumes that the column is called "id":

 

select count(id) as total_count

from table_name

group by id

;

 

 

[budimir]

Try something like the following query. It assumes that the column is called "id":

 

select count(id) as total_count

from table_name

group by id

;

 

 

 

Thanks a lot. That's it!!!

 

But now I'd like to display which is which. Can you help with that?

[fenway]

select id, count(id) as total_count

from table_name

group by id