/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 vote387 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote367 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote336 views1 answer
Wordpress sql change site url
SQL
0 vote343 views1 answer
Postgresql alter column nullable
SQL
1 vote373 views1 answer
Convert epoch to date in sql server
SQL
1 vote357 views1 answer
Oracle schema size
SQL
0 vote799 views2 answers
Zsh: command not found: mysq
SQL
9 votes392 views4 answers
Postgresql export database
SQL
2 votes327 views1 answer
Mysql list users on ubuntu
SQL
0 vote351 views1 answer
How to do a function to return row type from a table in pl/sql
SQL