‘壹’ sql语句如何将一个字段中每个数据出现的次数的多少进行排序，假设不知道这个字段中具体的值。
--将name次数 按多到少排序
select name from 表名 group by name order by count(1) desc
‘贰’ SQL 如何查出表A中全部数据并且根据表A的ID在表B中的出现次数排序。
select a.* from a inner join (select b.aid id, count(*) counts from b group by b.aid) tmp on a.id = tmp.id order by tmp.counts
select a.* from a inner join (select a.id id, count(*) counts from a left join b on a.id=b.aid group by a.id) tmp on a.id = tmp.id order by tmp.counts
select a.* from a left join (select b.aid id, count(*) counts from b group by b.aid) tmp on a.id = tmp.id order by isnull(tmp.counts, 0)
‘叁’ 关于SQL语句，按出现频率降序排列的问题
select top 10 percent 书名,count(*) as 借出次数 from 表 group by 书名 order by 借出次数 desc
以上，希望对你有所帮助！
‘肆’ SQL语句，如何统计一列中的值重复出现的次数，查询出的结果按次数的倒序排列
select 重复字段, count(重复字段) from 表 group by 重复字段 order by 重复字段 desc
‘伍’ sql语句查询出现次数
SQL语句如果汇总某字段中所有不重复值的出现次数，可以使用
select 字段,sum(字段) as 出现次数 from 表 group by 字段
‘陆’ sql 按照出现次数排序
select win , count (*) as num from table1 group by win order by num count (*)
不能用别名参与排序，改成这样子就行了
‘柒’ SQL如何查询出某一列中不同值出现的次数
1、首先需要创建一个临时表，用于演示如何筛选出表中指定字段值重复的记录数量。
‘捌’ SQL SERVER 根据某列的值的重复次数排序
select (case department when 'A' then 'A' when 'B' then 'B' when 'C' then 'C' end) as department,count(department) as f1 from tbele group by department order by count(department) desc
结果
department f1
A 3
C 2
B 1
‘玖’ mysql数据库：按某列的值的出现次数降序排列怎么写SQL语句注意，是按出现次数排序哈
select a,count(1) cnt from table group by a order by cnt desc