/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 vote246 views1 answer
Postrgres trunc
SQL
0 vote212 views1 answer
Sqlite3 now
SQL
1 vote240 views2 answers
T sql get foreign key
SQL
1 vote269 views2 answers
Full join
SQL
1 vote239 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote235 views1 answer
Tsql generate rows
SQL
0 vote241 views2 answers
How to get json data mysql
SQL
16 votes244 views5 answers
Select last row in sql
SQL
17 votes247 views4 answers
Sort by mysql
SQL
1 vote188 views1 answer
Postgres kill pid
SQL