[TOC] ## 自聯結 一個SQL表自行連接自己 給定下面的員工表，寫出一個SQL查詢，了解員工的工資，這些員工比其管理人員工資更多。對于上表來說，Joe是唯一一個比他的經理工資更多的員工 ``` +----+-------+--------+-----------+ | Id | Name | Salary | ManagerId | +----+-------+--------+-----------+ | 1 | Joe | 70000 | 3 | | 2 | Henry | 80000 | 4 | | 3 | Sam | 60000 | NULL | | 4 | Max | 90000 | NULL | +----+-------+--------+-----------+ SELECT a.Name as Employee FROM Employee as a JOIN Employee as b on a.ManagerID = b.Id WHERE a.Salary > b.Salary ```