/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 vote157 views1 answer
Sql bild in function
SQL
0 vote301 views1 answer
Why do we need data structure in sql
SQL
0 vote151 views1 answer
Recursive query herarchical data sql server
SQL
0 vote148 views1 answer
Mysql terminal list table
SQL
0 vote169 views1 answer
Sql log file inof
SQL
0 vote156 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote150 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote159 views1 answer
Drop database using terminal postgres
SQL
6 votes154 views1 answer
T-sql test if table exists
SQL
0 vote188 views2 answers
How to install psql in ubuntu
SQL