Find most frequent value in SQL column

by 
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.

More Related Contents:

  1. SQL select only rows with max value on a column [duplicate]
  2. How to create a MySQL hierarchical recursive query?
  3. How to reset AUTO_INCREMENT in MySQL
  4. SELECTING with multiple WHERE conditions on same column
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. How to find gaps in sequential numbering in mysql?
  7. MySQL: Invalid use of group function
  8. Combining UNION and LIMIT operations in MySQL query
  9. How do I use on delete cascade in mysql?
  10. MySQL JOIN the most recent row only?
  11. MySQL Group By and Sum total value of other column
  12. OUTPUT Clause in MySQL
  13. Search all columns of a table using a single where condition with single keyword in mysql
  14. What does SQL clause “GROUP BY 1” mean?
  15. Sorting by date & time in descending order?
  16. Case statement in MySQL
  17. MySQL, Concatenate two columns
  18. MySQL: Inner join vs Where [duplicate]
  19. Syntax error when using except in a query
  20. Selecting from two tables with inner join and limit [duplicate]
  21. Why the order of evaluation for expressions involving user variables is undefined?
  22. sql like operator on integer
  23. How to select data where a field has a min value in MySQL?
  24. MySQL – SELECT * INTO OUTFILE LOCAL ?
  25. How to SELECT by MAX(date)?
  26. The best way to remove value from SET field?
  27. get a recursive parent list
  28. Execute INSERT if table is empty?
  29. MySQL: Computed Column
  30. How do I extract Month and Year in a MySQL date and compare them?

Leave a Comment