找到比上级工资高的员工的名字
SELECT T1.NAME AS EMPLOYEE FROM EMPLOYEE T1
,EMPLOYEE T2
WHERE T1.MANAGERID = T2.ID
AND T1.SALARY > T2.SALARY
找到比上级工资高的员工的名字
最新推荐文章于 2022-02-25 16:50:23 发布
找到比上级工资高的员工的名字
SELECT T1.NAME AS EMPLOYEE FROM EMPLOYEE T1
,EMPLOYEE T2
WHERE T1.MANAGERID = T2.ID
AND T1.SALARY > T2.SALARY