/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 vote130 views1 answer
Sql query for login with email or username
SQL
0 vote121 views1 answer
Install squirrel sql ubuntu
SQL
0 vote117 views1 answer
Groupby error in mysql
SQL
0 vote111 views1 answer
Hw to delete a procedure in pl sql
SQL
1 vote126 views1 answer
Varchar plsql
SQL
0 vote116 views1 answer
Sql server bool select
SQL
0 vote123 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote119 views1 answer
How to add session data into mysql database from button
SQL
0 vote109 views1 answer
Change database name psql 8
SQL
0 vote118 views1 answer
Postgresql extract hour and minutes from timestamp
SQL