sql case when then ...虚心求教

显示全部楼层 · 2011-4-13 17:48:30

select
casesalary

when 5000then'高薪'

when 4500then'中薪'

when 3500then'中低薪'

else 'null'

end as '工资等级'

fromtelenolist
我想统计各个工资级别的人数
那个count(*)应该放在语句的哪里，还用再填写别的语句吗？。先谢谢了

千问 · 2011-4-13 17:48:30

select count(*) as cnt,casesalary
when 5000then'高薪'
when 4500then'中薪'
when 3500then'中低薪'
else 'null'
end as '工资等级'
fromtelenolistgroup bycasesalary
when 5000then'高薪'
when 4500then'中薪'
when 3500then'中低薪'
else 'null'

千问 · 2011-4-13 17:48:30

单独写一个查询语句：select 工资等级,count(工资等级) from table group by 工资等级