Question

mysql数据库：按某列的值的出现次数降序排列怎么写SQL语句？注意，是按出现次数排序哈

Answer 1

select a,count(1) cnt from table group by a order by cnt desc