1. Why is it so that the given query worked :"select * from (select rownum rnum,a.* from emp a) where rnum=70; "while this query dint work :"select * from (select rownum,a.* from emp a) where rownum=70;"2. as i've read that rownum can work only for < and or >=, then why the query worked for rnum=70

adarsh_sp

 Profile Answers by adarsh_sp Questions by adarsh_sp

• Oct 3rd, 2006

 

1. Alias name is required for rownum that is why the first query is working while second one not working

2. Its working because we used an alias name

Lavanya Chowdary

• May 6th, 2007

 

It will work for = operator
But it will work for the first row in the table pls check that

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 21st, 2008

 

ROWNUM returns a number indicating the order in which the row was retrieved from the table, but this is not always the order in which a row is displayed. 

If you directly user rownum in the outer query it considers the rownum of outer query not that of inner query.