《数据库开发-SQL-王坤朋》-课件设计(公开).pptVIP

为什么不能这么执行 ============================================================================================= *为什么不能这么执行* ============================================================================================= SELECT 3, 1.1 货物贸易, A.S_BANKORGCODE, SUM(CASE WHEN A.C_TYPE = I AND A.D_PAYEEDATE BETWEEN DTHISMONTHSTART AND DTHISMONTHEND THEN A.F_AMT ELSE 0 END) AS F_AMT1,--收入部分本期发生额 SUM(CASE WHEN A.C_TYPE = I AND A.D_PAYEEDATE BETWEEN DTHISYEARSTART AND DTHISMONTHEND THEN A.F_AMT ELSE 0 END) AS F_AMT2,--收入部分1—当月累计额 SUM(CASE WHEN A.C_TYPE = I AND A.D_PAYEEDATE BETWEEN DLASTYEARSTART AND DLASTMO