find nth or 5th highest record of salary

Awful Anaconda answered on June 16, 2021 Popularity 1/10 Helpfulness 1/10

answer find nth or 5th highest record of salary

related find nth or 5th highest record of salary

Comment

SELECT Salary
FROM Worker W1
WHERE 4 = (
 SELECT COUNT( DISTINCT ( W2.Salary ) )
 FROM Worker W2
 WHERE W2.Salary <= W1.Salary
 );

Popularity 1/10 Helpfulness 1/10 Language whatever

Tags: find highest record whatever

Link to this answer
Share Copy Link

Contributed on Jun 17 2021

Awful Anaconda

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

SELECT Salary FROM Worker ORDER BY Salary DESC LIMIT n-1,1;
SELECT SALARY FROM Worker ORDER BY Salaly DESC LIMIT 5,1;

Popularity 1/10 Helpfulness 1/10 Language whatever

Tags: find highest record whatever

Link to this answer
Share Copy Link

Contributed on Jun 16 2021

Awful Anaconda

0 Answers Avg Quality 2/10

Comment

SELECT Salary FROM Worker ORDER BY Salary DESC LIMIT 5,1

Popularity 1/10 Helpfulness 1/10 Language whatever

Tags: record whatever find highest

Link to this answer
Share Copy Link

Contributed on Jun 16 2021

Awful Anaconda

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.