什么都不说直接上干货。
select T.* from
(
select *,row_number() over(order by id) as rn from tablename
) T
where rn between N and M
什么都不说直接上干货。
select T.* from
(
select *,row_number() over(order by id) as rn from tablename
) T
where rn between N and M