Select
  *
From (
   SELECT
        %s
        ,rownum R
   FROM
        (SELECT *
        FROM %s
        %s
        )
   )
WHERE R BETWEEN %s AND %s