/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 vote149 views1 answer
Normalization in database
SQL
0 vote133 views2 answers
Cambiar nombre tabla mysql
SQL
3 votes134 views2 answers
Sql paging query
SQL
0 vote154 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote159 views1 answer
Psql no such file or directory
SQL
2 votes156 views1 answer
Mysql select true or false
SQL
0 vote132 views1 answer
Array aggre distinct postgres
SQL
2 votes139 views1 answer
Oracle drop table free up space
SQL
4 votes151 views1 answer
SQL find text in SP
SQL
13 votes141 views3 answers
Insert mysql ifile nto database
SQL