比如取第20行到第60行
select
订单ID,行数
from
(
SELECT
订单ID,
ROW_NUMBER() OVER() AS 行数
FROM 订单
)
WHERE 行数>=20 and 行数<=60
select * from (select rownum as rn,* from table where rownum<=60) t where t.rn>=20
1min目标场景问卷
立即参与
