find who has most entries

[Palli]

I have a database of 300,000 entries. All have an id field. I want to find out who has the most entries in the database.... is this possible. I can't seem to find anything online.

I have tried

SELECT COUNT(id)
FROM myTable

[legendx]

SELECT user_id, count(id) as total FROM myTable GROUP BY user_id ORDER BY total DESC


Add a LIMIT or TOP, depending on your database, to only retrieve the user with the most records.

[Palli]

perfect thanks :):):):)