/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 vote221 views1 answer
Query to get all primary keys and foreign key
SQL
1 vote236 views1 answer
Rails run native ssql query
SQL
0 vote204 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL
0 vote244 views1 answer
Php mysqli install
SQL
0 vote221 views1 answer
Mysql function variable
SQL
9 votes236 views1 answer
No sql
SQL
7 votes258 views2 answers
Sql remove duplicates based on column
SQL
0 vote221 views1 answer
Docker export psql sql
SQL
2 votes233 views2 answers
Convert_tz mysql
SQL
5 votes227 views3 answers
Select tables from mysql database
SQL