/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 vote151 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote162 views1 answer
Insert ip address in mysql
SQL
1 vote146 views1 answer
Login to database mysql terminal
SQL
9 votes157 views4 answers
SQL Date Format
SQL
17 votes176 views3 answers
Postgresql list users
SQL
0 vote156 views4 answers
How to connect form to database
SQL
0 vote111 views1 answer
Bigquery information_schema schema all columns
SQL
4 votes156 views2 answers
Show all database inside postgresql
SQL
0 vote164 views1 answer
How to locate pg_hba.conf file
SQL
0 vote202 views1 answer
Mysql faster delete
SQL