Share
Find the 4th Highest employee salary from the following table
Question
sirajp99
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Answers ( 2 )
using limit (4,1) at the end of statement
SELECT Salary FROM (SELECT Salary FROM Employee ORDER BY salary DESC LIMIT 4)
SELECT salary
FROM (SELECT *, DENSE_RANK() OVER (ORDER BY SALARY DESC ) as r
FROM table_name )
WHERE r=4 ;