/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

1 vote165 views1 answer
Varchar plsql
SQL
3 votes209 views1 answer
Mysql group_concat distinct
SQL
0 vote157 views1 answer
Gcloud sql list databases
SQL
7 votes149 views2 answers
3rd height salary sql
SQL
0 vote134 views1 answer
Json not contains mysql
SQL
0 vote144 views1 answer
Get all employees if name ends with in sql
SQL
0 vote132 views1 answer
Mysql sql select one day before
SQL
0 vote144 views1 answer
Change filed order in mysql
SQL
0 vote133 views1 answer
Ms sql database data size
SQL
19 votes169 views6 answers
Create table sqlite
SQL