Home » SQL & PL/SQL » SQL & PL/SQL » simple but knowledgeable pls help
simple but knowledgeable pls help [message #222370] Sat, 03 March 2007 07:47 Go to next message
aboodlardy
Messages: 80
Registered: November 2006
Location: India
Member
Hi

After checking the query to find nth row in a table on this forum. I tried ( JUST TO LEARN) with rownum, what I have done is
1. select sal from emp where rownum=1 order by sal;
it gives me the 1st row. Then

IN ORDER TO GET 5TH ROW
2. select sal from emp where rownum=5 order by sal;
but it gives me no rows selected.
why this strange behavior.???

Please help me.
Re: simple but knowledgeable pls help [message #222371 is a reply to message #222370] Sat, 03 March 2007 07:58 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Go through below link
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:948366252775



hope this helps
Taj
Previous Topic: PK and FK one one column
Next Topic: Problem with Equijoin in SQL
Goto Forum:
  


Current Time: Thu Dec 08 22:16:36 CST 2016

Total time taken to generate the page: 0.09100 seconds