/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 vote178 views1 answer
Oracle simple quote
SQL
0 vote163 views2 answers
Insert into
SQL
2 votes135 views1 answer
Latest record in sql
SQL
1 vote279 views1 answer
Alter constraint postgres
SQL
10 votes184 views2 answers
Forgot my mysql password mac
SQL
22 votes168 views4 answers
Show list of users in mysql
SQL
0 vote192 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
0 vote208 views1 answer
How to check database engine in mysql
SQL
0 vote179 views1 answer
Normalization in database
SQL
0 vote177 views1 answer
Couldn't execute 'SELECT COLUMN_NAME
SQL