第一种:
- SELECT *
- FROM (SELECT ROW_.*, ROWNUM ROWNUM_
- FROM (SELECT *
- FROM TABLE1
- WHERE TABLE1_ID = XX
- ORDER BY GMT_CREATE DESC) ROW_
- WHERE ROWNUM <= 20)
- WHERE ROWNUM_ >= 10;
第二种:
- SELECT *
- FROM (SELECT A.*, ROWNUM RN
- FROM (SELECT *
- FROM TABLE1
- WHERE TABLE1_ID = XX
- ORDER BY GMT_CREATE DESC) A)
- WHERE RN BETWEEN 10 AND 20;
第三种:
- SELECT *
- FROM (SELECT RID
- FROM (SELECT R.RID, ROWNUM LINENUM
- FROM (SELECT ROWID RID