/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 vote161 views1 answer
Mysql convert charset
SQL
1 vote170 views1 answer
Create new table in SQL from old table with data
SQL
19 votes179 views6 answers
Mysql if null
SQL
0 vote170 views1 answer
Sql server select record with max id
SQL
0 vote161 views1 answer
Sql fetch next 10 rows pdo
SQL
0 vote158 views1 answer
What is the essence of SQL?
SQL
0 vote196 views1 answer
Sql order by number not ordered
SQL
4 votes1.1K views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
0 vote319 views1 answer
Mysql delete entire row on condition
SQL
0 vote192 views1 answer
Get foreign table names mysql
SQL