SELECT * FROM sometable ORDER BY name OFFSET 20 ROWS FETCH NEXT 10 ROWS ONLY;
SELECT ROWNUM, a.* FROM (SELECT customers.* FROM customers WHERE customer_id > 4500 ORDER BY last_name) a;