/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

0 vote260 views1 answer
Character count sql
SQL
0 vote237 views1 answer
Select password from user mysql
SQL
0 vote249 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
1 vote258 views1 answer
Check if mysql is installed
SQL
1 vote267 views1 answer
Rails run native ssql query
SQL
3 votes271 views2 answers
Postgres inner join vs join
SQL
0 vote269 views1 answer
What does leave do in mysql
SQL
0 vote244 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote248 views1 answer
Cannot start database server xampp mac os
SQL
0 vote272 views1 answer
Count columns psql(PostreSQL)
SQL