select * from (select 表名 .*,rownum rc from 表名 where rownum<=endrow) a where a.rc>=startrow;
select * from 表名 limit startrow,pagesize; (pagesize为每页显示的记录条数)
select * from (select * from student where sid not in (select sid from student where rownum<=(currentpage-1)*pagesize) ) where rownum <=pagesize;
如对本文有疑问, 点击进行留言回复!!
Oracle 基本概念 Dadabase,schema,user,table...
dbeaver连接Oracle中文乱码的解决方案--druid
Oracle常用语句(时间格式、去重、去特殊符号、查询表空间等)
网友评论