/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

2 votes245 views2 answers
Set value to null sql
SQL
0 vote200 views1 answer
Drop constraint in ms sql
SQL
0 vote210 views1 answer
Mysql order by where condition sub query
SQL
0 vote231 views1 answer
Alter domain sql
SQL
8 votes231 views1 answer
Racle create auto increment column
SQL
0 vote211 views1 answer
Get date from timestamp in mysql
SQL
4 votes223 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote210 views1 answer
Sql server check whether column has same equal values
SQL
0 vote188 views1 answer
Cara menampilkan tabel yang tidak mengandung kata di sql server
SQL
0 vote204 views1 answer
Mysql join same table multiple times group by
SQL