Usage of rownum Oracle

SELECT * FROM t where rownum=1 can query out data, while select * from T where rownum=2 can not query out data. In the case of where rownum = 1, the first row passes the test, is output and rownum goes
to 2. No other row ever satisfies the predicate and rownum stays at 2 for the rest of
The query.
In the case of where rownum = 2, the first row is rownum 1, it fails. The next row is
ALSO rownum = 1 and likewise fails. And so on. There can be NO row 2 if there are not a
Row 1.

Usage of rownum Oracle