/SQL/How to find the most occuring in SQL

How to find the most occuring in SQL

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

Similar codes

2 votes256 views2 answers
Mysql write into table
SQL
2 votes324 views1 answer
Mysql create user with remote access
SQL
0 vote215 views1 answer
How to to get time in sql
SQL
7 votes317 views2 answers
Drop index oracle
SQL
0 vote211 views1 answer
Table values functions in SQL
SQL
20 votes198 views2 answers
Mysql bigint max value
SQL
0 vote324 views1 answer
Setting default value for Boolean data type in SQL
SQL
0 vote199 views1 answer
Mysql max number not returning correct value
SQL
2 votes190 views1 answer
Postgresql update sequence next value
SQL
0 vote204 views1 answer
Get employees if not contains in sql
SQL