/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 vote285 views1 answer
Opensuse start MySQL
SQL
0 vote308 views1 answer
Java nosql sort
SQL
1 vote336 views1 answer
How to see logical reads in sql server
SQL
0 vote288 views1 answer
Mysql jdbc timezone
SQL
0 vote303 views1 answer
Search starting with mysql
SQL
2 votes279 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote324 views1 answer
How to add mysql to path on termin after installation
SQL
2 votes277 views1 answer
Mysql select random id from table
SQL
0 vote245 views1 answer
Update sql join multiple tables
SQL
4 votes327 views6 answers
List all tables in postgres
SQL