OraFAQ Forum: SQL & PL/SQL » rownum grater than 1 (merged)

Home » SQL & PL/SQL » SQL & PL/SQL » rownum grater than 1 (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

rownum grater than 1 (merged) [message #388824]

Thu, 26 February 2009 05:36

ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad

Senior Member

Why we can't use Rownum with grater than?

select *from emp where rownum>=5;

why it's returning no rows

Report message to a moderator

Rownum with 1 [message #388827 is a reply to message #388824]

Thu, 26 February 2009 05:46

ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad

Senior Member

select * from emp where rownum=1;

why rownum works only with 1,why it's not working with other than 1 ?

Report message to a moderator

Re: Rownum with 1 [message #388828 is a reply to message #388827]

Thu, 26 February 2009 05:58

aviva4500
Messages: 122
Registered: July 2008
Location: bangalore

Senior Member

@ramesh55.sse,

1. It will work if you issue > or <....

2. http://blog.lishman.com/2008/03/rownum.html

3. Check the above link which gives you some idea on RowNum.

Regards,
Hammer

[Updated on: Thu, 26 February 2009 06:02]

Report message to a moderator

Re: rownum grater than [message #388834 is a reply to message #388824]

Thu, 26 February 2009 06:11

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why not reading the documentation?
Why not searching for this FAQ?

Regards
Michel

Report message to a moderator

Re: Rownum with 1 [message #388843 is a reply to message #388827]

Thu, 26 February 2009 06:19

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Rownum is assigned to a row as it is fetched from the database.

So,if you're looking for rownum >5, Oracle will get the first row, see the it's got rownum 1, and discard it.
It will then get the next row, see that it hasn't got any rows yet, give this onw a rownum of 1, check to see if it'srownum is > 5, and discard the row.
Repeat until out of rows.

Report message to a moderator

Previous Topic:	UNIX-Oracle Error
Next Topic:	java.sql.SQLException: Protocol violation (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 07:52:46 CST 2025