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

Question

Answer 1

如下：

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';