oracle_面试题

SELECT a.name ,IFNULL(b.name,"BOSS") FROM boss a  LEFT JOIN  boss b ON a.MANAGER_ID = b.ID

员工和经理对照 sql