# 181. Employees Earning More Than Their Managers ###### tags: `easy` `SQL` ![](https://i.imgur.com/QWXt22r.png) ![](https://i.imgur.com/KDOV5gh.png) SQL的join 在同一張表找尋比經理還賺錢的員工 在as一張表為t1 去比較薪水已經讓on id managerId ![](https://i.imgur.com/kXJaeFh.png) ![](https://i.imgur.com/6bMdeeS.png)