Back
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:
onetwotwothree
one
two
three
Try using the below code:
SELECT `column`, COUNT(`column`) AS `value_occurrence` FROM `my_table` GROUP BY `column` ORDER BY `value_occurrence` DESC LIMIT 1;
SELECT `column`,
COUNT(`column`) AS `value_occurrence`
FROM `my_table`
GROUP BY `column`
ORDER BY `value_occurrence` DESC
LIMIT 1;
Note: You can replace the column and my_table. You can also increase 1 if you want to see the N most common values of the column.
Enroll yourself in the SQL server certification to learn in-depth about SQL statements, queries and become proficient in SQL.
30.9k questions
32.9k answers
500 comments
665 users