is this query possible?

[tito]

I've got a table and in the first column I have
id = 5
id = 5
id = 12
id = 5
id = 8
id = 14
id = 12 etc ...

I'd like to get the count for uniqueid

for example
ID of 5 will be count 3
ID of 12 will be count 2
ID of 8 will be count of 1

1 - Is that possible?
2- Is it also possible to order the query by the bigger count returned?

Thanks

[devphp12]

hi try this query

SELECT
Count(id_table.id),id
FROM
id_table
GROUP BY
id_table.id

[tito]

Thank you