/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 vote137 views2 answers
Connect to mysql server mac terminal
SQL
0 vote140 views1 answer
Oracle query to find schema you are working on
SQL
1 vote135 views1 answer
Postgresql can you have null foreign key
SQL
0 vote143 views1 answer
Sql convert unix time to date
SQL
13 votes126 views6 answers
Current date sql
SQL
2 votes131 views2 answers
Useradd postgres
SQL
0 vote139 views1 answer
Oracle archivemode
SQL
15 votes136 views3 answers
Mysql update add to existing value
SQL
1 vote157 views1 answer
Psql search table
SQL
10 votes136 views4 answers
SELECT FROM WHERE
SQL