SQL ROWNUM how to return rows between a specific range July 11, 2022 by Tarik SELECT * from ( select m.*, rownum r from maps006 m ) where r > 49 and r < 101