/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 vote146 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote95 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
0 vote140 views2 answers
What is 1=2 in sql
SQL
0 vote209 views1 answer
How to update random rows in sql
SQL
6 votes1.2K views1 answer
Sql select second max
SQL
11 votes128 views2 answers
Insert date sql
SQL
-1 vote127 views1 answer
How to use update trigger in sql
SQL
0 vote126 views2 answers
Add new column after in sql
SQL
0 vote146 views1 answer
Mysql default uuid
SQL
0 vote148 views1 answer
How to add mysql to path on termin after installation
SQL