Oracle分页查询的实现主要依靠rownum伪列实现的,当rownum作为新表的属性是,记得使用别名;
select a.* from (select q.* ,rownum rn from Student q where rownum <=20 ) a where a.rn>10
Oracle分页查询的实现主要依靠rownum伪列实现的,当rownum作为新表的属性是,记得使用别名;
select a.* from (select q.* ,rownum rn from Student q where rownum <=20 ) a where a.rn>10