/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

3 votes209 views1 answer
Set default today mysql
SQL
0 vote197 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
2 votes210 views1 answer
Sql server current date minus 5 years
SQL
0 vote177 views1 answer
Mariadb list tables
SQL
0 vote204 views1 answer
Postgres enumerated type
SQL
3 votes194 views4 answers
Show sql server database
SQL
0 vote219 views1 answer
How we can perform acid Operations in sql with examples
SQL
1 vote205 views2 answers
Mysql remove first and last character from string
SQL
-1 vote248 views4 answers
Full outer join in sql
SQL
1 vote225 views2 answers
Mysql add column tinyint default 0
SQL