select employeeid, lastname, managerid, salary
from employees
start with employeeid = 150
connect by employeeid = prior managerid
from employees
start with employeeid = 150
connect by employeeid = prior managerid
显示150号员工的依次领导信息
最新推荐文章于 2024-04-30 20:14:14 发布
本文介绍如何使用SQL语句从员工表中选择特定字段，并通过递归查询实现员工层级关系的展示。
扫一扫
1529
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
