employees
,其中包含员工的ID和上级的ID,你可以使用以下查询来找到某个员工的上级:,,``sql,WITH RECURSIVE EmployeeHierarchy AS (, SELECT employee_id, manager_id, FROM employees, WHERE employee_id = ? 替换为你要查询的员工ID, UNION ALL, SELECT e.employee_id, e.manager_id, FROM employees e, INNER JOIN EmployeeHierarchy eh ON e.employee_id = eh.manager_id,),SELECT * FROM EmployeeHierarchy;,
``,,这个查询会返回从指定员工到最高级的上级的所有层级关系。sql,SELECT * FROM employees WHERE department_id IN (SELECT id FROM departments WHERE name = 'Sales');,
`,,这个例子中,内层子查询
(SELECT id FROM departments WHERE name = 'Sales')` 首先找到销售部门的所有 ID,然后外层查询使用这些 ID 来筛选员工表中属于销售部门的员工。Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.