select id,
sum(decode(month,1,pay,2,pay,3,pay,0)季度1,
sum(decode(month,4,pay,5,pay,6,pay,0)季度2,
sum(decode(month,7,pay,8,pay,9,pay,0)季度3,
sum(decode(month,10,pay,11,pay,12,pay,0)季度4,
from table1 group by id
sum(decode(month,1,pay,2,pay,3,pay,0)季度1,
sum(decode(month,4,pay,5,pay,6,pay,0)季度2,
sum(decode(month,7,pay,8,pay,9,pay,0)季度3,
sum(decode(month,10,pay,11,pay,12,pay,0)季度4,
from table1 group by id
select id,ceil(month,3) 季度,sum(pay) from table1 group by id,ceil(month,3)