select * from (select * from (select rownum as rownums,t.* from TRAN_LIST t)
where rownums<=2*5) where rownums>(2-1)*5;
select * from (
select ROWNUM RN,t.* from TRAN_LIST t where ROWNUM<=2*5 )tmp
where tmp.RN >(2-1)*5
select * from (select * from (select rownum as rownums,t.* from TRAN_LIST t)
where rownums<=2*5) where rownums>(2-1)*5;
select * from (
select ROWNUM RN,t.* from TRAN_LIST t where ROWNUM<=2*5 )tmp
where tmp.RN >(2-1)*5
本文标题：Oracle 分页两
本文链接：https://www.haomeiwen.com/subject/rnhslktx.html
网友评论