sql查询语句大全 Oracle分页查询SQL语句

本篇文章主要介绍了"sql查询语句大全 Oracle分页查询SQL语句"，主要涉及到sql查询语句大全方面的内容，对于Oracle感兴趣的同学可以参考一下： 1.无排序SELECT * FROM (Select ROWNUM AS ROWNO, T.* from k_task T where Fli...

1.无排序

SELECT *
 FROM (Select ROWNUM AS ROWNO, T.*
      from k_task T
     where Flight_date between to_date('20060501', 'yyyymmdd') and
        to_date('20060731', 'yyyymmdd')
      AND ROWNUM <= 20) TABLE_ALIAS
WHERE TABLE_ALIAS.ROWNO >= 10;

2.有排序

SELECT *
 FROM (SELECT TT.*, ROWNUM AS ROWNO
      FROM (Select t.*
          from k_task T
          where flight_date between to_date('20060501', 'yyyymmdd') and
             to_date('20060531', 'yyyymmdd')
          ORDER BY FACT_UP_TIME, flight_no) TT
     WHERE ROWNUM <= 20) TABLE_ALIAS
where TABLE_ALIAS.rowno >= 10;

以上就介绍了sql查询语句大全 Oracle分页查询SQL语句，包括了sql查询语句大全方面的内容，希望对Oracle有兴趣的朋友有所帮助。

本文网址链接：http://www.codes51.com/article/detail_2217758.html