如何获取名称和管理器名称

brgchamk 于 2021-06-17 发布在 Mysql

关注(0)|答案(3)|浏览(300)

如何获取姓名和经理姓名

+----+-----------+---------+
| id | name      | manager |
+----+-----------+---------+
|  1 | bhupendra |       0 |
|  2 | shyam     |       1 |
|  3 | ram       |       1 |
|  4 | geeta     |       2 |
|  5 | sita      |       1 |
+----+-----------+---------+

我需要这样的结果

+-----------+-----------+
| name      | manager   |
+-----------+-----------+
| bhupendra |           |
| shyam     | bhupendra |
| ram       | bhupendra |
| geeta     | shyam     |
| sita      | bhupendra |
+-----------+-----------+

sql mysql select

来源：https://stackoverflow.com/questions/53958391/how-to-get-name-and-manager-name

3条答案

按热度按时间

vh0rcniy1#

应该使用alias两次使用同一个表

select a.name, b.name as manager 
from my_table a 
left join  my_table b on a.manager  = b.id

赞(0）回复(0）举报 2021-06-18

z6psavjg2#

你可以自己加入 id 上的列 manager 列：

SELECT    e.name AS name, m.name AS manager
FROM      employee e
LEFT JOIN employee m ON m.id = e.manager

赞(0）回复(0）举报 2021-06-18

ca1c2owp3#

看看这个

with recursive cte (id, name, parent_id) as (
  select     id,
             name,
             manager
  from       employee
  union all
  select     p.id,
             p.name,
             p.manager
  from       employee e
  inner join cte
          on p.manager = cte.id
)
select * from cte;

赞(0）回复(0）举报 2021-06-18

我来回答

如何获取名称和管理器名称

3条答案

相关问题

热门标签

最新问答