Question

SQL语句如何统计一列中的值重复出现的次数,查询出的结果按次数的倒序排列？

Answer 1

用GROUP BY，例如：
SELECT 分类字段,COUNT(*) FROM 表名称 GROUP BY 1 ORDER BY 2 DESC

Answer 2

select 要统计的列名,count(*) from table
group by 要统计的列名
order by count(*) desc

Answer 3

select 列名,count(*) from table
group by 列名
order by count(*) desc