/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 vote329 views1 answer
Call procedure in wordpress
SQL
0 vote325 views1 answer
Convert sql server guid to varbinary
SQL
9 votes325 views2 answers
Mysql change value
SQL
0 vote383 views1 answer
Traccar mysql
SQL
0 vote318 views1 answer
Alter precision
SQL
0 vote328 views3 answers
Convert sql query to python pandas
SQL
1 vote320 views1 answer
Select statement to print longest name
SQL
0 vote369 views1 answer
Primary key start from number
SQL
0 vote342 views1 answer
Kill a pid redshift
SQL
1 vote354 views1 answer
How to copy data of a table from another database to table of anaother database
SQL