select name,sum(decode(money_type,'01',money)) money1,
sum(decode(money_type,'02',money)) money2,
sum(decode(money_type,'05',money)) money3
from tbname
where money_type in('01','02','05') group by name;
sum(decode(money_type,'02',money)) money2,
sum(decode(money_type,'05',money)) money3
from tbname
where money_type in('01','02','05') group by name;
from table1
where money_type in ('01' , '02' , '05')
group by name