Find the Nth largest salary from employee table.

Question

Best way to get the Nth highest salary from a table.
Table name – Employee
Columns – Emp_id, salary,depar

in progress 1
Ritika Sohal 4 years 3 Answers 978 views Member 0

Answers ( 3 )

    0
    Reply

    select * from (select *, dense_rank() over(order by salary DESC) highest_salary from employee) where highest_salary = n;

  2. Puja
    0
    Reply

    Select salary from Employee
    order by salary desc
    limit n-1,1

  3. Sai
    1
    Reply

    Use OFFSET and LIMIT to get the Nth highest salary. We can use Dense_Rank() or Sub Query to get the same output.

    Select Salary from Employee
    ORDER BY Salary Desc
    LIMIT n-1 ,1

Leave an answer

Browse
Browse