/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

2 votes131 views3 answers
Sql server: how to concatenate column data using comma
SQL
10 votes116 views4 answers
Mysql one week ago
SQL
2 votes109 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote106 views1 answer
Execute sql stored procedure in powershell
SQL
1 vote147 views1 answer
Size of all tables in a schema oracle
SQL
0 vote110 views1 answer
Mariadb cast to int
SQL
3 votes122 views1 answer
Oracle list invalid password logon denied
SQL
8 votes134 views1 answer
My sql version
SQL
0 vote125 views1 answer
Python connect to mysql in settings.py
SQL
0 vote108 views1 answer
Mysql docker image for macbook m1
SQL