sql语句查询 同一id的数据合并

如下：

select a.id
    ,a.amount1 as "amount1",a.amount2 as "amount2" 
    ,b.amount1 as "amount3",b.amount2 as "amount4"
    ,c.amount1 as "amount5",c.amount2 as "amount6"
from `表一` as a 
left join `表一` as b on a.id = b.id and b.type='B'
left join `表一` as c on a.id = c.id and c.type='C'
where a.type='A';

https://www.jianshu.com/p/8f929264995e

group by id