Question

SQL SERVER 根据某列的值的重复次数排序

table1：
id department
1 A
2 B
3 C
4 A
5 A
6 C

查询结果按a、b、c的出现次数由大到小排序
结果应该是如: A , C , B ..

Answer 1

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

Answer 2

select * from (
select department, count（*）as count
from table1
group by department
) order by count desc