+----+-------+--------+-----------+|Id|Name|Salary|ManagerId|+----+-------+--------+-----------+|1|Joe|70000|3||2|Henry|80000|4||3|Sam|60000|NULL||4|Max|90000|NULL|+----+-------+--------+-----------+Employee表中,ManagerId為空的是經(jīng)理,找出薪水高于經(jīng)理的雇員名字。我使用:selects.NamefromEmployeesjoinEmployeeions.ManagerId=i.Idwheres.Salary>i.Salary;這樣寫,有更好的寫法嗎?
Mysql 單個(gè)表查詢問題
慕虎7371278
2019-04-19 16:11:29