Oracle - SELECT ordered with LIMIT and OFFSET

limitandoffset.sql

-- SELECT with LIMIT and OFFSET in MySQL

SELECT id, name FROM table ORDER BY name LIMIT 100 OFFSET 50;



-- SELECT with LIMIT and OFFSET in Oracle

SELECT a.id, a.name
  FROM (SELECT b.id, b.name,
               rownum b_rownum
          FROM (SELECT c.id, c.name
                  FROM table c
                 ORDER BY b.name) b
         WHERE rownum <= 100) a
 WHERE b_rownum >= 50