1. 查询前10条记录
SELECT * FROM TABLE WHERE ROWNUM <= 10
2. 查询第11到第20条记录
SELECT * FROM (SELECT T.*, ROWNUM RN FROM TABLE T WHERE ROWNUM <=20) WHERE RN > 10
3. 按照UPDATE字段降序排列后的前10条记录
SELECT * FROM (SELECT * FROM TABLE ORDERY BY UPDATE ASC) WHERE ROWNUM <= 10
4. 按照UPDATE字段升序排列后的第11到第20条记录
SELECT * FROM (SELECT T.*, ROWNUM RN FROM (SELECT * FROM TABLE ORDER BY UPDATE ASC) T WHERE ROWNUM <=20) WHERE RN > 10