/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

2 votes299 views1 answer
Sql skip the first row
SQL
4 votes334 views2 answers
Oracle drop job
SQL
0 vote302 views1 answer
Sqlite higher or equal
SQL
0 vote317 views1 answer
Ms sql filter all sympbol
SQL
0 vote312 views1 answer
How to reset table in sql server
SQL
16 votes314 views2 answers
Add column if not exists mysql
SQL
1 vote321 views1 answer
Oracle enable job
SQL
2 votes320 views1 answer
Orcale index size
SQL
12 votes301 views4 answers
Mysql version query
SQL
2 votes316 views2 answers
Mysql find max value row
SQL