| Pls clear my doubt [message #8849] |
Tue, 30 September 2003 02:58  |
hanuma
Messages: 5
Registered: June 2003
|
Junior Member |
|
|
Could you pls explain in detail
....FROM ( SELECT e.ename 5 , e.sal 6 , rank() OVER ( ORDER BY sal DESC, ename ASC ) r 7 FROM emp e 8 ) x
|
|
|
|
|
|
| Re: Pls clear my doubt [message #8860 is a reply to message #8849] |
Tue, 30 September 2003 11:54  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
|
It is an inline view with embedded SQL*Plus line numbers that uses an analytical function (rank) to sort and rank employees by descending salary and ascending name.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
