This discussion is archived
8 Replies Latest reply: Apr 10, 2012 8:04 PM by 850247 RSS

why Rownum=(more than 1) is not work

402451 Newbie
Currently Being Moderated
if i fired
select * from table where rownum=1;
it gives me frist row.
select * from table where rownum<=2;
it gives me frist two rows then why
select * from table where rownum=2;
not gives me second row.
it gives no row selected.

please clear me .........
thanks in advance