/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

1 vote138 views1 answer
Sql to mongodb query converter
SQL
11 votes196 views2 answers
Sql between date range
SQL
0 vote124 views1 answer
MySql get primary keys of table
SQL
0 vote127 views1 answer
How to check xampp mysql password
SQL
0 vote112 views1 answer
How to execute stored output to csv files
SQL
0 vote116 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote145 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote178 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote215 views1 answer
Insensitive case match sqlalchemy
SQL
0 vote120 views2 answers
Sqlite unix timestamp
SQL