Nth max salary using Analytic function
|
|
|
Question / Problem
|
How to get Nth max salary using analytic function?
|
Solution
|
Select empid,ename,sal,rank from (select empid,ename,sal,rank() over(order by sal) from emp) where rank=n (n can be any value).
|
Applies to |
|
Oracle 9i Sql
|
Rank It |
|
