/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

6 votes359 views3 answers
Psql show columns of table
SQL
1 vote335 views1 answer
Sql current timestamp
SQL
1 vote287 views2 answers
Mysql SELECT
SQL
0 vote319 views1 answer
Get sum sqlite android
SQL
2 votes312 views1 answer
Oracle current date without time
SQL
2 votes306 views1 answer
Mysql time ago difference
SQL
0 vote319 views1 answer
Search column name sql
SQL
0 vote310 views3 answers
Get count of null in column sql
SQL
7 votes322 views3 answers
How ot change name of column mysql
SQL
1 vote342 views1 answer
Liquibase alter column type / length
SQL