/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 votes233 views1 answer
Sqlite insert if not exists
SQL
6 votes202 views2 answers
Postgresql database url
SQL
0 vote198 views1 answer
Sql how to get courses that i have made prerequisites
SQL
2 votes207 views1 answer
Guid to string sql
SQL
0 vote215 views2 answers
Mysql calcular idade
SQL
3 votes288 views2 answers
Savepoint in sql
SQL
6 votes245 views2 answers
How to get last element sql
SQL
0 vote198 views1 answer
Sql add calculated column
SQL
0 vote230 views1 answer
Sqlalchemy query join many to many
SQL
7 votes191 views3 answers
Sql get last inserted row
SQL