Question

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





Answer 1

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