select e.id, e.name, e.salary
from employee e
where Exists (select * from employee a where e.employeeid = a.managerid)
from employee e
where Exists (select * from employee a where e.employeeid = a.managerid)
查询是领导的员工信息
最新推荐文章于 2023-03-06 15:09:06 发布
扫一扫
1599
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
