-
Notifications
You must be signed in to change notification settings - Fork 4
problam #32
Answered
by
iamAntimPal
IamShiwangi
asked this question in
Q&A
problam
#32
-
Beta Was this translation helpful? Give feedback.
All reactions
Answered by
iamAntimPal
Mar 21, 2025
WITH
RankedEmployees AS (
SELECT *, DENSE_RANK() OVER(ORDER BY salary DESC) AS `rank`
FROM Employee
)
SELECT MAX(salary) AS SecondHighestSalary
FROM RankedEmployees
WHERE `rank` = 2;
explanation click on me for explain
Replies: 1 comment
-
WITH
RankedEmployees AS (
SELECT *, DENSE_RANK() OVER(ORDER BY salary DESC) AS `rank`
FROM Employee
)
SELECT MAX(salary) AS SecondHighestSalary
FROM RankedEmployees
WHERE `rank` = 2;
explanation click on me for explain
Beta Was this translation helpful? Give feedback.
All reactions
0 replies
Answer selected by
IamShiwangi
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment