Yes because rownum is in the order that it is fetched in if looks at the first rownum and it's 1 and it doesn't meet the criteria it discards it. The next result it fetches also has the row of 1 because it discards the first result. It follows you will get zero results.