/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 vote340 views1 answer
How to find sql server name
SQL
1 vote296 views1 answer
Postgres grant read only access to database
SQL
0 vote378 views1 answer
Oracle current timestamp insert statement
SQL
0 vote350 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
13 votes357 views3 answers
Sql select from multiple tables without join
SQL
1 vote361 views1 answer
Sql server list locks
SQL
0 vote336 views1 answer
Sql search all columns of database oracle sql
SQL
3 votes374 views1 answer
Oracle list privileges
SQL
8 votes352 views2 answers
Grant all privileges database postgres to user
SQL
2 votes377 views2 answers
Calculate percentage in sql
SQL