/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

8 votes269 views8 answers
Second highest salary in mysql
SQL
3 votes317 views2 answers
To_char oracle
SQL
1 vote326 views1 answer
How to start with sql
SQL
0 vote327 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote303 views2 answers
Sql update top 100
SQL
0 vote319 views1 answer
Mysql persistence.xml
SQL
1 vote312 views2 answers
Last working day in week date function in sql
SQL
1 vote316 views2 answers
Mysql filter by date mount
SQL
0 vote317 views1 answer
Sql list dates between two dates
SQL
14 votes333 views3 answers
Inner join sql oracle
SQL