/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

0 vote254 views1 answer
Sqlite woth cmake
SQL
7 votes209 views1 answer
Forge server hosting
SQL
0 vote222 views4 answers
Mysql replace regex
SQL
0 vote254 views1 answer
Mysql collation portugues brasil
SQL
1 vote233 views1 answer
Show structure of table in sql
SQL
0 vote255 views1 answer
Cannot pip install mysqlclient
SQL
0 vote221 views1 answer
Default value false mysql
SQL
0 vote232 views1 answer
Mysql create pool
SQL
11 votes227 views3 answers
Change column name sql server management studio
SQL
1 vote233 views1 answer
Launch sql script from docker in mysql
SQL