Thread: rownum in 9i
View Single Post
  #1 (permalink)  
Old 09-04-2007, 11:49 PM
ashish2345 ashish2345 is offline
Junior Member
 
Join Date: Sep 2007
Posts: 3
ashish2345 is on a distinguished road
Default 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
Reply With Quote

ANSWER(S):