[SOLVED] Find most frequent value in SQL column

Issue

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

Solution

SELECT
  <column_name>,
  COUNT(<column_name>) AS `value_occurrence` 

FROM
  <my_table>

GROUP BY 
  <column_name>

ORDER BY 
  `value_occurrence` DESC

LIMIT 1;

Replace <column_name> and <my_table>. Increase 1 if you want to see the N most common values of the column.

Answered By – Mihai Stancu

Answer Checked By – Katrina (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published.