8 Replies Latest reply: Apr 10, 2012 10:04 PM by 850247 RSS

    why Rownum=(more than 1) is not work

    402451
      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