/SQL/Sql select most frequent value in column

Sql select most frequent value in column

SELECT col, COUNT(col) AS value_occurrence
FROM m_table GROUP BY col ORDER BY value_occurrence DESC LIMIT 1;

-- Oracle <= 11g
SELECT * FROM (SELECT col, COUNT(col) AS value_occurrence
FROM m_table GROUP BY col ORDER BY value_occurrence DESC)
WHERE rownum = 1;

Similar codes

0 vote287 views1 answer
Table or view does not exist
SQL
0 vote301 views1 answer
Excel vba import data to sql server
SQL
1 vote281 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
-1 vote291 views1 answer
Module operator in oracle sql
SQL
2 votes293 views1 answer
Q operator in sql
SQL
9 votes281 views1 answer
Oracle get table schema
SQL
2 votes292 views1 answer
Oracle drop sequence if exists
SQL
1 vote297 views1 answer
Declare table variable
SQL
0 vote296 views1 answer
Alter check command
SQL
0 vote294 views2 answers
Mysql row_number() example
SQL