ANY dialect question:
rownum in 9i
Hi friends
when ever i try to use rownum function other than < or <= it gives no row selected like
select * from emp where rownum=2;
select * from emp where rownum>=3;
no row selected while emp hav 14 rows..
plz reply
|