如何编写该sql语句？？ 谢谢

Question

select id,
       decode(type,'first',number) first,
       decode(type,'second',number) second,
       decode(type,'third',number) third
from tableA;

Answer 1

SELECT id,SUM(DECODE(type,'first',number)) 'first', 
       SUM(DECODE(type,'second',number)) 'second', 
       SUM(DECODE(type,'third',number)) 'third'
FROM exp_table 
GROUP BY id

Answer 2

今天、我運気不好、又与楼上一秒相差  hoho

Answer 3

select id,
       sum(decode(type,'first',number)) first,
       sum(decode(type,'second',number)) second,
       sum(decode(type,'third',number)) third
from tableA
group by id;