表m只有一个字段n,如下:
a
b
b
c
a
b
d
设计一条SQL语句,先统计相同内容数据的个数,之后按个数的多少排序。
方法有二,1:select n,count(*) from m group by n ouder by count(*) desc
2:select n,count(n) from m group by n order by count(n) desc