34,594
社区成员
发帖
与我相关
我的任务
分享
declare @m smallint
declare @n smallint
set @m = 5
set @n = 10
select * from
(
select
ROW_NUMBER() OVER(ORDER BY item_id) r_id,c_item.*
from c_item
) T_test
where r_id between @m and @m + @n
select * from
(
select * , ROW_NUMBER() OVER(ORDER BY id) px from tb
) t
where px between m and m+n