database - SQL ROWNUM how to return rows between a specific range

Question

How can I return a specific range of ROWNUM values?

I'm trying the following:

select * from maps006 where rownum >49 and rownum <101

This returns only rows matching the < operator.

question from:https://stackoverflow.com/questions/4552769/sql-rownum-how-to-return-rows-between-a-specific-range

Answer 1

 SELECT * from
 (
 select m.*, rownum r
 from maps006 m
 )
 where r > 49 and r < 101