xmmc y1 y2 y3 y4 y5 y6 y7 y8 y9 y10 y11 y12 ?
项目 1月 2月 3月 4月 5月 6月 7月 8月 9月 10月 11月 12月 合计
项目1 20 30 20 70 80 60 90 70 100 67.50 80 35 722.50
项目2 10 20 10 60 70 50 80 60 90 57.50 80 35 622.50
......
合计 30 50 30 130 150 110 150 130 190 125 160 70 1345.00
东拼西凑找的一段sql语句，查出来的只有1到12月的数据，没有横向合计和纵向合计的数据
select *
from (
select (select j.id from j where j.id = t.id) as id,
(select j.xmmc from j where j.id = t.id) as xmmc,
sum(decode(t.yf, '1', t.jg,0.00)) as y1,
sum(decode(t.yf, '2', t.jg,0.00)) as y2,
sum(decode(t.yf, '3', t.jg,0.00)) as y3,
sum(decode(t.yf, '4', t.jg,0.00)) as y4,
sum(decode(t.yf, '5', t.jg,0.00)) as y5,