/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 vote227 views2 answers
Limit sqlserver
SQL
2 votes179 views1 answer
Mysql clear screen
SQL
5 votes137 views1 answer
Postgres upsert
SQL
2 votes175 views1 answer
Oracle table size
SQL
0 vote180 views1 answer
Sql query to force the database to be drop
SQL
6 votes188 views2 answers
Oracle trigger
SQL
0 vote231 views1 answer
Mariadb disable foreign key checks
SQL
0 vote291 views1 answer
Python get backup of sql
SQL
0 vote213 views1 answer
Wordpress make wp user in db
SQL
17 votes177 views6 answers
Current date in sql
SQL