/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 vote183 views1 answer
Mysql multiple count
SQL
10 votes187 views1 answer
User_dependencies
SQL
0 vote184 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote182 views1 answer
Conda install pymysql "windows"
SQL
0 vote201 views1 answer
Primary key multiple
SQL
1 vote181 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote186 views1 answer
Increase speed of like queries postgres
SQL
0 vote195 views1 answer
Create bdd mysql
SQL
1 vote171 views1 answer
Mysql show data from table
SQL
0 vote181 views1 answer
Mysql identified by syntax error
SQL