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.