本文介绍了一种使用SQL查询特定范围记录的方法。通过嵌套查询结合ROWNUM实现对指定表（如SubscribeReqTbl）中数据的高效检索，特别是针对按ORDERID降序排列的数据集。
查询1-10条的记录
select * from (select rownum as r,t.* from (select * from SubscribeReqTbl where 1 = 1 and REQTYPE <>0 order by ORDERID desc) t where rownum<= 10 ) where r> 0
Oracle分页
查询1-10条的记录
select * from (select rownum as r,t.* from (select * from SubscribeReqTbl where 1 = 1 and REQTYPE <>0 order by ORDERID desc) t where rownum<= 10 ) where r> 0
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
