/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

1 vote216 views1 answer
Print year of a date sql
SQL
-1 vote172 views1 answer
Round up and down sql
SQL
4 votes278 views6 answers
Laravel jwt
SQL
0 vote164 views1 answer
How to reset table in sql server
SQL
0 vote173 views1 answer
Add created and updatedAt fields in mysql
SQL
0 vote174 views1 answer
What is the use of index in mysql table
SQL
0 vote214 views1 answer
Grouping by email domain mysql
SQL
0 vote180 views1 answer
Rows, INSERT INTO, Returning
SQL
0 vote163 views1 answer
Commit transaction sql
SQL
0 vote230 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL