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

csr21
Profile Answers by csr21 Questions by csr21
Sep 11th, 2006
7
2308

Showing Answers 1 - 7 of 7 Answers

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.