How can I find the most frequent value in a given column in an SQL table?
For example, for this table it should return
two since it is the most frequent value:
one two two three
SELECT <column_name>, COUNT(<column_name>) AS `value_occurrence` FROM <my_table> GROUP BY <column_name> ORDER BY `value_occurrence` DESC LIMIT 1;
1 if you want to see the
N most common values of the column.
Answered By – Mihai Stancu
Answer Checked By – Katrina (BugsFixing Volunteer)