Weub的博客

原创 ORACLE分页查询总结

基本查询模板SELECT * FROM (SELECT a.*, ROWNUM AS rn FROM (SELECT * FROM table_name) a) WHERE ROWNUM <= 40) WHERE rn >= 21;其中最内层的 SELECT * FROM table_name 查询所有数据 通过外面两层分别限制查询的 ROWNUM 为21-40之