/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 votes222 views3 answers
Raw select laravel
SQL
36 votes207 views6 answers
Delete from where sql
SQL
22 votes188 views4 answers
Show list of users in mysql
SQL
0 vote200 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
0 vote194 views1 answer
Csv to sqlite python
SQL
-1 vote214 views1 answer
Utf8_encode mysql
SQL
10 votes197 views2 answers
Sql rtrim
SQL
1 vote197 views1 answer
How to use a trigger to validate input data
SQL
0 vote191 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
1 vote197 views1 answer
Login to database mysql terminal
SQL