/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

0 vote241 views1 answer
Access refused mysql xampp server
SQL
8 votes255 views1 answer
Mysql restore database
SQL
-1 vote259 views1 answer
Sql set max value in column
SQL
0 vote241 views1 answer
Sql server update top n records
SQL
0 vote270 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
0 vote249 views1 answer
Table values functions in SQL
SQL
0 vote279 views1 answer
Primary key multiple
SQL
0 vote275 views1 answer
Mysql insert into select transaction c#
SQL
6 votes267 views1 answer
Oracle list primary key
SQL
0 vote247 views1 answer
How to export table data from mysql table in sql format
SQL