SELECT foo
  FROM bar
 ORDER BY 1
 LIMIT 5, 10

##</code><code>##

SELECT foo
  FROM (
        SELECT foo
          FROM bar
         ORDER BY 1
       )
 GROUP BY 1
 HAVING ROWNUM >= 5
    AND ROWNUM <= 10