SELECT * FROM ( SELECT ROWNUM PGQ_RN, PGQ_SUB.* FROM (

.... original select query ....

) PGQ_SUB ) WHERE PGQ_RN BETWEEN 6 AND 10

SELECT * 
FROM
(
  SELECT (select count(*) from mytbl where col1='abc') row_cnt
    , row_number() over ( order by col2) rn, mytbl.*  
  FROM mytbl
  WHERE col1='abc'
)
WHERE 5<= rn AND rn <= 10