查询出来的 PRI*QTY-PRI1*QTY1 这块数据不对 请问我这个查询有错误嘛
SELECT NAM,REPNUM,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 1, (PRI*QTY)-(PRI1*QTY1), 0)) AS 一月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 2, (PRI*QTY)-(PRI1*QTY1), 0)) AS 二月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 3, (PRI*QTY)-(PRI1*QTY1), 0)) AS 三月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 4, (PRI*QTY)-(PRI1*QTY1), 0)) AS 四月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 5, (PRI*QTY)-(PRI1*QTY1), 0)) AS 五月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 6, (PRI*QTY)-(PRI1*QTY1), 0)) AS 六月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 7, (PRI*QTY)-(PRI1*QTY1), 0)) AS 七月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 8, (PRI*QTY)-(PRI1*QTY1), 0)) AS 八月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 9, (PRI*QTY)-(PRI1*QTY1), 0)) AS 九月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 10, (PRI*QTY)-(PRI1*QTY1), 0)) AS 十月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 11, (PRI*QTY)-(PRI1*QTY1), 0)) AS 十一月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 12, (PRI*QTY)-(PRI1*QTY1), 0)) AS 十二月,
SUM((PRI*QTY)-(PRI1*QTY1)) AS 总计
FROM TABLE
SELECT NAM,REPNUM,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 1, (PRI*QTY)-(PRI1*QTY1), 0)) AS 一月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 2, (PRI*QTY)-(PRI1*QTY1), 0)) AS 二月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 3, (PRI*QTY)-(PRI1*QTY1), 0)) AS 三月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 4, (PRI*QTY)-(PRI1*QTY1), 0)) AS 四月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 5, (PRI*QTY)-(PRI1*QTY1), 0)) AS 五月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 6, (PRI*QTY)-(PRI1*QTY1), 0)) AS 六月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 7, (PRI*QTY)-(PRI1*QTY1), 0)) AS 七月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 8, (PRI*QTY)-(PRI1*QTY1), 0)) AS 八月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 9, (PRI*QTY)-(PRI1*QTY1), 0)) AS 九月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 10, (PRI*QTY)-(PRI1*QTY1), 0)) AS 十月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 11, (PRI*QTY)-(PRI1*QTY1), 0)) AS 十一月,
SUM(DECODE(EXTRACT(MONTH FROM DAT), 12, (PRI*QTY)-(PRI1*QTY1), 0)) AS 十二月,
SUM((PRI*QTY)-(PRI1*QTY1)) AS 总计
FROM TABLE
那你这个sql的语法没有错啊
那你这个sql的语法没有错啊有group by , 但是 我得出的数据都是0 .很奇怪
我直接查询的 没有create和insert脚本 啊
我直接查询的 没有create和insert脚本 啊那算了,你慢慢研究吧