elee1969 (7/3/2013)
manikanta1207 (7/3/2013)
what is the query to select nth highest salary of emp tableselect MAX(Salary) from Employee;
this really sounds like homework....
anyway,
the nth highest , ie the second or third, requires the use if a subquery and row_number, or nested top X queries with opposite ORDER BY commands.
SELECT * FROM (select row_number() over(partition by order by.....) myAlais Where RW = 3
Lowell