/SQL/Find most frequent value in SQL column

Find most frequent value in SQL column

SELECT       `column`,
             COUNT(`column`) AS `value_occurrence` 
    FROM     `my_table`
    GROUP BY `column`
    ORDER BY `value_occurrence` DESC
    LIMIT    1;

Similar codes

0 vote154 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote228 views1 answer
Sqlite version check
SQL
0 vote208 views1 answer
Create table in dbms cmds
SQL
0 vote219 views1 answer
Mysql command prompt date insert format
SQL
0 vote202 views1 answer
Mysql auto increment in YY-MM-XXX format
SQL
13 votes218 views4 answers
Command line mysql import
SQL
4 votes194 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
2 votes203 views1 answer
Q operator in plsql
SQL
0 vote194 views1 answer
Azure sql server check foreign key
SQL
0 vote227 views1 answer
How to check foreign key constraint in sql
SQL