/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

1 vote176 views1 answer
Substr sql last character
SQL
15 votes191 views2 answers
How to know the username of postgresql
SQL
2 votes146 views5 answers
Alter table primary key postgresql
SQL
0 vote232 views1 answer
Mysql faster delete
SQL
0 vote195 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote201 views1 answer
Get last updated row sql server
SQL
0 vote187 views1 answer
Mysql join same table multiple times group by
SQL
-1 vote244 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote187 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote273 views1 answer
ORA-00942
SQL