一个有关oracle分页sql的问题，在线等候。

Question

刚才说错了，sorryselect rownum no,t.* from (select t.message_id,t.modify_time from message_information t order by t.modify_time )t  where no >30

Answer 1

是不是8I不支持？
我在9。0。0。1上测试通过
SQL> SELECT ID,AID,ROWNUM FROM TEST_DG  ORDER BY ID;ID                                                   AID     ROWNUM
--------------------------------------------- ---------- ----------
1(AID)                                                 1          5
1(CID)                                                 2          6
2(AID)                                                 2          1
2(CID)                                                 3          2
3(AID)                                                 3          7
3(CID)                                                 1          8
4(AID)                                                 4          3
4(CID)                                                 4          48 rows selectedSQL> SELECT * FROM (SELECT ID,AID,ROWNUM FROM TEST_DG  ORDER BY ID ) WHERE AID>2;ID                                                   AID     ROWNUM
--------------------------------------------- ---------- ----------
2(CID)                                                 3          2
3(AID)                                                 3          7
4(AID)                                                 4          3
4(CID)                                                 4          4

Answer 2

oracle 8i以下不支持子查询排序。