/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 vote138 views1 answer
How to get last client id sql
SQL
11 votes211 views5 answers
Laravel db facade
SQL
0 vote372 views1 answer
Get first match in each group mysql query
SQL
0 vote185 views1 answer
Pl sql disable trigger
SQL
1 vote183 views1 answer
Alphabetical order mysql
SQL
17 votes181 views4 answers
Show tables sql server
SQL
0 vote236 views1 answer
Sql select first and last record of each group
SQL
7 votes188 views1 answer
Mysql iif
SQL
4 votes193 views5 answers
Primary key
SQL
0 vote241 views1 answer
Count database access django
SQL