-
Notifications
You must be signed in to change notification settings - Fork 4
LeetCode SQL Hard Problam #26
Answered
by
iamAntimPal
IamShiwangi
asked this question in
Q&A
-
Beta Was this translation helpful? Give feedback.
All reactions
Answered by
iamAntimPal
Mar 22, 2025
# Write your MySQL query statement below
SELECT d.Name as Department,
e.Name as Employee,
e.Salary as Salary
FROM Department d, Employee e
WHERE(
SELECT COUNT(distinct Salary)
FROM Employee
WHERE Salary > e.Salary AND DepartmentId = d.Id
) < 3 AND e.DepartmentId = d.Id
ORDER BY d.Id, e.Salary desc;
Replies: 2 comments
-
# Write your MySQL query statement below
SELECT d.Name as Department,
e.Name as Employee,
e.Salary as Salary
FROM Department d, Employee e
WHERE(
SELECT COUNT(distinct Salary)
FROM Employee
WHERE Salary > e.Salary AND DepartmentId = d.Id
) < 3 AND e.DepartmentId = d.Id
ORDER BY d.Id, e.Salary desc;
Beta Was this translation helpful? Give feedback.
All reactions
0 replies
Answer selected by
IamShiwangi
-
Thank You I understand that Question.
Beta Was this translation helpful? Give feedback.
All reactions
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment