Home » SQL & PL/SQL » SQL & PL/SQL » Significance of ROWNUM =1 (Oracle)
Significance of ROWNUM =1 [message #326407] Wed, 11 June 2008 06:33 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Why Using ROWNUM = 2 in SQL query does not return records whether ROWNUM =1 works?
Re: Significance of ROWNUM =1 [message #326412 is a reply to message #326407] Wed, 11 June 2008 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference, ROWNUM

Regards
Michel
Re: Significance of ROWNUM =1 [message #326418 is a reply to message #326407] Wed, 11 June 2008 06:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
On ROWNUM and Limiting Results

Regards
Michel

Re: Significance of ROWNUM =1 [message #326419 is a reply to message #326407] Wed, 11 June 2008 06:44 Go to previous messageGo to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
A ROWNUM value is assigned to a row after it passes the predicate phase of the query but before the query does any sorting or aggregation.

[Updated on: Wed, 11 June 2008 06:46]

Report message to a moderator

Re: Significance of ROWNUM =1 [message #326425 is a reply to message #326419] Wed, 11 June 2008 06:52 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sarwagya wrote on Wed, 11 June 2008 13:44
A ROWNUM value is assigned to a row after it passes the predicate phase of the query but before the query does any sorting or aggregation.

This is not completly true.
You will take advantage to read the links I posted.

Regards
Michel

Previous Topic: SELECT THE DATA WITH ANY CASE
Next Topic: Default tables and data from scott schema required
Goto Forum:
  


Current Time: Mon Dec 05 15:22:19 CST 2016

Total time taken to generate the page: 0.08035 seconds