WITH itemgoodsdeptHistory AS ( -- Anchor member: 找到指定员工 SELECT DeptID,ParentID,DeptName,treeItem,addby FROM itemgoodsdept WHERE deptid = '00757' UNION ALL -- Recursive member: 找到下级员工 SELECT e.DeptID, e.ParentID, e.DeptName,e.treeItem,e.addby FROM itemgoodsdept e INNER JOIN itemgoodsdeptHistory eh ON e.parentID = eh.Deptid ) select * from itemgoodsdeptHistory; --delete from itemgoodsdept where deptid in ( --select deptid from itemgoodsdeptHistory);