34,590
社区成员
发帖
与我相关
我的任务
分享
;with tmp
as
(select *,
rownum=row_number()over(order by huzhbiha)
from dbo.tb_item)
select *
from tmp
where rownum>40000
select * from
(select row_number() over(order by huzhbiha) indexs,* from dbo.tb_item) t
where indexs>40000
select * from
(select row_number() over(order by huzhbiha) indexs,* from dbo.tb_item) t
where indexs between 1 and 40000