/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 vote207 views1 answer
Convert sql server guid to varbinary
SQL
0 vote215 views1 answer
Mysqldump ignore table
SQL
0 vote239 views1 answer
Oracle current date minus 1 day
SQL
0 vote239 views1 answer
Java nosql sort
SQL
4 votes231 views2 answers
Oracle unlock account
SQL
0 vote232 views1 answer
How to find columns with null values in sql
SQL
2 votes198 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
16 votes233 views3 answers
Jwt secret key generator laravel
SQL
0 vote168 views1 answer
Connection error in mysql workbench
SQL
1 vote234 views2 answers
How to combine 2 tables in MySQL
SQL