学习地址:https://www.cnblogs.com/cs-forget/p/7978547.html
比如每页三行,要查询第二页,则相当于查4,5,6条,起始行4= (页码-1)每页长度+1,结束行6=页码每页长度
select rownum,id,name from (
select rownum rn , t.* from test t where rownum <=6) n
where n.rn>=4
学习地址:https://www.cnblogs.com/cs-forget/p/7978547.html
比如每页三行,要查询第二页,则相当于查4,5,6条,起始行4= (页码-1)每页长度+1,结束行6=页码每页长度
select rownum,id,name from (
select rownum rn , t.* from test t where rownum <=6) n
where n.rn>=4