Select Code to Download

SELECT foo
  FROM bar
 ORDER BY 1
 LIMIT 5, 10

SELECT foo
  FROM (
...
 GROUP BY 1
 HAVING ROWNUM >= 5
    AND ROWNUM <= 10