/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 vote201 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote212 views1 answer
Oracle exchange partition
SQL
0 vote220 views2 answers
Starts and end with vowel sql
SQL
0 vote255 views1 answer
Sqlite3 pragma foreign keys
SQL
0 vote321 views1 answer
Sql insert exemplo
SQL
3 votes302 views1 answer
Postgresql today - 1 year
SQL
0 vote195 views1 answer
Oarcale list objects
SQL
0 vote276 views1 answer
Soql last week
SQL
3 votes184 views1 answer
Postgresql if null then 0
SQL
0 vote229 views1 answer
Oracle list datafiles
SQL