ITPub博客

SELECT * FROM (          SELECT t.*, ROWNUM rn          FROM (SELECT * FROM user ORDER BY id) t) WHERE rn between 1 AND 10; SELECT * FROM (     SELECT t.*, ROWNUM rn     FROM (SELECT * FROM user ORDER BY id) t     WHERE ROWNUM <= 10) WHERE rn >= 1;