下面的语句现在取的值'aa','bb','cc','dd','ee'都是1000,
怎么才能排除province列的北京,湖南,取aa=前1000行,bb=前500行,cc=前1500行,dd=前1100行,ee=前600
use kc1
select * into #rr
from
(select * from tabel1)
as aaa
where province not in('北京','湖南')
ORDER BY mdn,labelname,province,city
select t.*
into kc2..[tabel2]
from
(select mdn,labelname,province,city, row_number()
over (partition by labelname order by labelname desc)
rn
from #rr) t
where rn<=1000
and labelname in('aa','bb','cc','dd','ee')