Most Occurances of a field

[LucidParody]

I have a table which stores users and votes. It looks something like this:

id | user | vote
1-----a-----3
1-----b-----5
1-----c-----1
2-----a-----4
2-----b-----5
3-----b-----2
etc, etc

If I want to query the table for the ID with the most votes (i.e. how many times a table value occurs), how would I do that?

[LordShryku]

SELECT id, count(*) AS cnt
FROM table
GROUP BY id
ORDER BY cnt DESC

Group on what you want to use as the common field, then count. The order by will put the highest number at the top.

[LucidParody]

Thanks much! 🙂