/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 vote364 views1 answer
Yesql
SQL
1 vote264 views1 answer
Oracle compile schema
SQL
0 vote329 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote340 views1 answer
Provide hardcoded value in the mysql query
SQL
1 vote284 views1 answer
Alter user mysql native password
SQL
0 vote345 views3 answers
Remove folders from remote git
SQL
0 vote371 views1 answer
How to compile a function in oracle
SQL
0 vote310 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
1 vote334 views3 answers
Execute sp in sql server
SQL
0 vote315 views1 answer
Postgresql if else endif
SQL