| doubt in rownum [message #265003] |
Wed, 05 September 2007 04:11  |
meeta
Messages: 28
Registered: January 2000
|
Junior Member |
|
|
Hi,
I am executing the below query and getting the O/P as below
SQL> SELECT ROWNUM rn,salary FROM emp ORDER BY salary ;
RN SALARY
---------- ----------
3 100
2 200
1 300
4 500
5 600
Can anyone tell me why ROWNUM RN is coming like above,ROWNUM should come as 1,2,3,4,5
|
|
|
|
| Re: doubt in rownum [message #265007 is a reply to message #265003] |
Wed, 05 September 2007 04:21  |
ShivrajGutte
Messages: 21
Registered: April 2007
Location: PUNE
|
Junior Member |
|
|
Hi,
While executing the above query Count operation (For rownum) is executing before the order by operation.
If u do the explain plan for this query ,U will get the idea.
regards
Shirvaj
|
|
|
|
|
|
|
|
| Re: doubt in rownum [message #265021 is a reply to message #265007] |
Wed, 05 September 2007 04:50 |
meeta
Messages: 28
Registered: January 2000
|
Junior Member |
|
|
Thanks shivraj for your reply, I have attached my explain plain in the file
In my explain pla, I am getting rows as 4 whereas my query shows 5 rows as well as can tell me what does cost mean????
[mod-edit] removed illiterate IM speak. If you won't, I will.
[Updated on: Wed, 05 September 2007 07:51] by Moderator Report message to a moderator |
|
|
|
| Re: doubt in rownum [message #265037 is a reply to message #265003] |
Wed, 05 September 2007 05:24 |
muzahid
Messages: 281
Registered: September 2004
Location: Dhaka, Bangladesh
|
Senior Member |
|
|
Your desire output may be come from the following query
SELECT rank() over (order by sal) rn, sal FROM emp ORDER BY sal
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
