/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 vote134 views1 answer
Sql date between one week
SQL
0 vote97 views1 answer
Sqlalchemy.exc.DBAPIError: (ibm_db_dbi.Error) ibm_db_dbi::Error: SystemError('<built-in function connect> returned NULL without setting an error')
SQL
1 vote140 views1 answer
Funzioni plsql
SQL
0 vote154 views1 answer
Creating a simple notify in postgresql
SQL
-1 vote135 views2 answers
Sql query examples
SQL
10 votes152 views3 answers
Sql select between two dates
SQL
17 votes173 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote143 views1 answer
Sql last 7 days
SQL
0 vote152 views1 answer
Mysql get first 2 characters of string
SQL
0 vote140 views1 answer
Doesn't have default value mysql
SQL