/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 vote120 views1 answer
Materialized view redshift
SQL
0 vote124 views1 answer
Get last three characters in mysql column
SQL
5 votes127 views1 answer
Sql integer to serial
SQL
0 vote115 views1 answer
Sql server get date of previous sunday
SQL
1 vote109 views1 answer
Postgresql convert text to float
SQL
15 votes124 views4 answers
Export mysql db using command line
SQL
0 vote114 views1 answer
Hw to delete a procedure in pl sql
SQL
12 votes119 views5 answers
Rename table in mysql
SQL
-1 vote131 views3 answers
How to restart mysql in linux
SQL
2 votes125 views1 answer
Grant revoke privileges to mysql username
SQL