/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 vote129 views1 answer
With_for_update sqlalchemy
SQL
9 votes119 views2 answers
Get first 3 letters in sql
SQL
0 vote126 views2 answers
Mysql on update current_timestamp
SQL
0 vote118 views1 answer
How to get initials in sql
SQL
7 votes127 views1 answer
Sql management studio display line numbers
SQL
1 vote127 views1 answer
Oracle list data files
SQL
5 votes145 views1 answer
Oracle sysdate - 1 month
SQL
3 votes117 views1 answer
MySQL DELETE JOIN
SQL
-1 vote142 views1 answer
Pl sql drop trigger
SQL
0 vote139 views1 answer
Sql remove first character from string
SQL