Employees Earning More Than Their Managers"/>
Employees Earning More Than Their Managers
看似复杂,其实很简单,两表内连接就好了
/
SELECT E1.Name FROM Employee E1
INNER JOIN Employee E2
WHERE E1.Salary>E2.Salary AND E1.ManagerId=E2.Id
更多推荐
Employees Earning More Than Their Managers
发布评论