Limit Offset

SELECT *
FROM (
  SELECT
    ROWNUM rnum,
    s.*
  FROM (
    SELECT *
    FROM sometable t
    ORDER BY t.sort_order ASC
  ) s
)
WHERE rnum BETWEEN 0 AND 10