/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

2 votes271 views1 answer
Node and mysql like
SQL
1 vote242 views1 answer
Database run
SQL
9 votes267 views2 answers
Get first 3 letters in sql
SQL
1 vote270 views1 answer
Mysql sort by date column
SQL
0 vote291 views1 answer
Database xml sql
SQL
0 vote289 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
11 votes339 views2 answers
Import mysql dump command line windows
SQL
0 vote292 views1 answer
View to table sql
SQL
0 vote270 views1 answer
Sql create table with references not primary key
SQL
0 vote292 views1 answer
Create table in dbms cmds
SQL