横表转纵表小例子

select * from quot_team_member t;

select t.quot_record_id quot,
sum (case t.role_type_id when 1180000063232 then t.billing_split_pct else 0 end) as type1,
sum (case t.role_type_id when 1180000063233 then t.billing_split_pct else 0 end) as type2
from quot_team_member t group by t.quot_record_id;