上图中reportsTo 列的数据是manager id,找出manager的查询方法如下:SELECT CONCAT(m.lastname,', ',m.firstname) AS 'Manager', CONCAT(e.lastname,', ',e.firstname) AS 'Direct report'FROM employees eINNER JOIN employees m O
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号