/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

1 vote309 views1 answer
Oracle show execution plan
SQL
0 vote273 views1 answer
Not equal to blank in mysql
SQL
2 votes283 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
2 votes274 views1 answer
How to get weekday from old date in sql
SQL
4 votes274 views1 answer
Describe table mysql
SQL
0 vote279 views1 answer
Sql server create constraint
SQL
1 vote272 views1 answer
Postgres concat_ws
SQL
1 vote270 views1 answer
Order by oracle
SQL
1 vote266 views1 answer
Sql server get users
SQL
1 vote305 views3 answers
Read all columns of a table sql
SQL