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

oracle_面试题-LMLPHP

员工和经理对照 sql

05-11 18:11