/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

3 votes251 views2 answers
How to View column names of a table in SQL
SQL
0 vote241 views1 answer
Mysql select distinct date from timestamp
SQL
0 vote277 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote264 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote275 views4 answers
Stored procedure sql
SQL
3 votes258 views1 answer
Mssql remove column
SQL
2 votes258 views1 answer
Sql get the name of user pc
SQL
1 vote286 views2 answers
Procedure syntax
SQL
0 vote265 views1 answer
Sql contains vs like
SQL
0 vote277 views1 answer
Create table as select sql server error
SQL