/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 vote347 views1 answer
Mysql drop key
SQL
0 vote315 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote340 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote313 views1 answer
Including parameters in OPENQUERY
SQL
3 votes352 views3 answers
Stop mysql ubuntu
SQL
-1 vote351 views3 answers
My sql alter table
SQL
3 votes307 views3 answers
Print in pl sql
SQL
6 votes338 views2 answers
Drop foreign key
SQL
0 vote354 views1 answer
Enable outgoing remote MySQL access
SQL
12 votes376 views6 answers
Distinct in sql server
SQL