数据库三个工资段各段人数

[MatrixRevolutions]

题目：
查询工资（sal）<2000,2000-4000,sal >4000的三个工资段 ------每个工资段的人数！

要求一条SQL语句！

[mayanzs]

select count(case when sal<2000 then 1 else null end) xy2000,
         count(case when sal>=2000 and sal<4000 then 1 else null end) y2000_4000,
         count(case when sal>4000 then 1 else null end) dy4000
  from yourTable;

[mayanzs]

select count(case when sal<2000 then 1 else null end) xy2000, count(case when sal>=2000 and sal<4000 then 1 else null end y2000_4000, count(case when sal>4000 then 1 else null end) dy4000 from yourTable;

[zbdzjx]

select sum(case when sal<2000 then 1 else 0 end) xy2000,
         sum(case when sal>=2000 and sal<=4000 then 1 else 0 end) y2000_4000,
         sum(case when sal>4000 then 1 else 0 end) dy4000
  from yourTable;