select '60以下' as [类型],count(1) as [人数] from [表] where [成绩]<60
union all
select '60-84' as [类型],count(1) as [人数] from [表] where [成绩]>=60 and [成绩]<84
union all
select '85以上' as [类型],count(1) as [人数] from [表] where [成绩]>=85

------解决方案--------------------
好像只能用union联接查询了吧，case when 方法达不到这样的显示效果。
探讨


SQL code


select '60以下' as [类型],count(1) as [人数] from [表] where [成绩]<60
union all
select '60-84' as [类型],count(1) as [人数] from [表] where [成绩]>=60 and [成绩]<84
union all
select '85以上' as [类型],count(1……