/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

5 votes286 views2 answers
Sql server port number
SQL
0 vote279 views1 answer
Mysql error 1452
SQL
1 vote279 views1 answer
Spring postgresql reset auto increment to 0
SQL
1 vote250 views1 answer
MySQL AND Operator
SQL
1 vote274 views1 answer
Mysql view current queries
SQL
2 votes273 views1 answer
How to delete view in sql
SQL
5 votes275 views1 answer
Minecraft java port number
SQL
-1 vote307 views2 answers
Sql search all tables for attributes
SQL
0 vote278 views1 answer
How to declare variable date in mysql
SQL
6 votes286 views1 answer
How to get the size of the database in postgresql
SQL