Content-Length: 300132 | pFad | http://github.com/iamAntimPal/LeetCode_SQL_Database/discussions/26

25 LeetCode SQL Hard Problam · iamAntimPal LeetCode_SQL_Database · Discussion #26 · GitHub
Skip to content

LeetCode SQL Hard Problam #26

Answered by iamAntimPal
IamShiwangi asked this question in Q&A
Discussion options

You must be logged in to vote
# 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;

Explanation

Replies: 2 comments

Comment options

You must be logged in to vote
0 replies
Answer selected by IamShiwangi
Comment options

You must be logged in to vote
0 replies
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Category
Q&A
Labels
None yet
2 participants








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/iamAntimPal/LeetCode_SQL_Database/discussions/26

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy