oracle查询某月消费总额,返回一条记录，显示1-12月(telfeedate字段)每个月的销售总额(factration字段)[ORACLE]...

SELECT

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’01’, Table1.factration)) AS JAN,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’02’, Table1.factration)) AS FRI,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’03’, Table1.factration)) AS MAR,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’04’, Table1.factration)) AS APR,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’05’, Table1.factration)) AS MAY,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’06’, Table1.factration)) AS JUE,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’07’, Table1.factration)) AS JUL,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’08’, Table1.factration)) AS AGU,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’09’, Table1.factration)) AS SEP,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’10’, Table1.factration)) AS OCT,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’11’, Table1.factration)) AS NOV,

SUM(decode(TO_CHAR(Table1.telfeedate, ’mm’), ’12’, Table1.factration)) AS DEC

FROM Table1