You should be able do it with minus and two subqueries. in oracle: select ... where rownum < 150 minus select ... where rownum < 100