/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 vote99 views1 answer
Json_remove mysql
SQL
0 vote127 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote138 views1 answer
How to make sure two tables have same exact data in sql
SQL
2 votes122 views1 answer
Select a certain number of entries from select mysql
SQL
1 vote105 views1 answer
Mysql remove last empty newline
SQL
4 votes105 views2 answers
Oracle drop job
SQL
0 vote142 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
0 vote157 views1 answer
Sql if clause within where clause
SQL
0 vote104 views1 answer
Traccar mysql
SQL
-1 vote59 views1 answer
Oracle db list usernames
SQL