find nth or 5th highest record of salary
SELECT Salary FROM Worker ORDER BY Salary DESC LIMIT 5,1find nth or 5th highest record of salary
SELECT Salary FROM Worker ORDER BY Salary DESC LIMIT 5,1find nth or 5th highest record of salary
SELECT Salary
FROM Worker W1
WHERE 4 = (
SELECT COUNT( DISTINCT ( W2.Salary ) )
FROM Worker W2
WHERE W2.Salary <= W1.Salary
);find nth or 5th highest record of salary
SELECT Salary FROM Worker ORDER BY Salary DESC LIMIT n-1,1;
SELECT SALARY FROM Worker ORDER BY Salaly DESC LIMIT 5,1;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
