SELECT b.*, rownum FROM (SELECT A.*, ROWNUM RN FROM (SELECT * FROM tableName) A ) b WHERE RN BETWEEN 21 AND 40