把你现在的数据,截图出来。然后自己用excel模拟一下你到底要什么效果?
用父级主键关联主键,然后父级主键为null的就行
select a.* from 部门表 a
join 部门表 b on a.父级主键=b.主键
where 1=1
and a.父级主键 is null
![1697608818675188.png image.png](/upload/wenda/20231018/1697608818675188.png)
select
b.company_name as 一级部门,
a.company_name as 二级部门
from aaatbbb a
join (select * from aaatbbb where my_value is null ) b on a.my_value=b.month_code_s
![1697609735811986.png image.png](/upload/wenda/20231018/1697609735811986.png)
![1697609725241051.png image.png](/upload/wenda/20231018/1697609725241051.png)