oracle scott用户emp表下显示所有领导手下员工

2025-03-23 21:52:40
推荐回答(1个)
回答1:

SELECT t1.ename, wm_concat(t2.ename)
FROM scott.emp t1, scott.emp t2
where t1.empno = t2.mgr
group by t1.ename;