SQL语句统计

whcjx

针对于员工销售统计表Yg_Xs,字段分别为员工号NUMB，员工负责客户区域AREA，销售收入SR，如何用SQL语句统计出每一客户区域销售收入排前3名的员工.谢谢！

rollingpig

如果yg_xs里的numb对应单个销售总额，使用:
select * from Yg_xs where
numb =
(select numb from
(select numb,rank() over (partition by area order by sr desc) as r from Yg_Xs)
where r < 4
)

如果yg_xs里的numb对应多个销售记录，则使用:
select * from Yg_xs where
numb =
(select numb from
(select numb,rank() over (partition by area order by sr desc) as r from
(select sum(sr) sr,numb ,area from yg_xs group by numb ,area
)
where r < 4
)