Originally Posted by ashish2345

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