/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

20 votes378 views5 answers
Reset auto increment mysql
SQL
2 votes368 views1 answer
Sqlite3 show columns name
SQL
0 vote353 views1 answer
Soql last week
SQL
4 votes364 views2 answers
Convert utc to est sql
SQL
0 vote337 views1 answer
Sql select non unique
SQL
0 vote377 views1 answer
Oracle execute package dblink
SQL
0 vote352 views1 answer
Mql5 list all available symbols
SQL
4 votes360 views1 answer
Oracle select first 10 rows
SQL
3 votes356 views2 answers
Mysql select database
SQL
0 vote317 views1 answer
CREATE MULTIPLE FK
SQL