给你一个例子吧, 你自己都部给例子!!!!!????
把每个省的前十名员工找出来
rs (人事表)rs010 工号,rs050 省份,......select * from (
select *, (select count(*) from rs where rs010 <= R2.rs010 and rs050 = R2.rs050) as n from rs R2
) B where n <= 10 order by rs050, rs010
把每个省的前十名员工找出来
rs (人事表)rs010 工号,rs050 省份,......select * from (
select *, (select count(*) from rs where rs010 <= R2.rs010 and rs050 = R2.rs050) as n from rs R2
) B where n <= 10 order by rs050, rs010
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货