22,210
社区成员
发帖
与我相关
我的任务
分享
--2000
select rn = identity(int,1,1),* into #temp
from tb
select *
from #temp
where rn between 3 and 5 -- 3到5的取出来。
--2005
select *
from(select rn = row_number() over (order by getdate()),* from tb)u
where rn between 3 and 5 -- 3到5的取出来。
select top 3 * from tb where id not in(select top 2 id from tb)