SELECT M1.YY_TYPE,SUM(COALESCE(M1.DAY_VALUE,0)) AS IND_VALUE FROM (
SELECT
CASE WHEN A.SUB_ORI_SUBJECT ='ZJ_ZJMXBG02' THEN '经营性资金'
WHEN A.SUB_ORI_SUBJECT LIKE 'ZJ_ZJMXBI02' THEN '专项资金'
ELSE 'UNKNOW' END AS YY_TYPE,
DAY_VALUE
FROM
[Devdb].A_FIN_TOT_INFO A
WHERE
A.DEPA_CODE IN ( select
mmi.OPTION_CODE
from
[Devdb].SYS_MESSAGE_INFO mmi
where
mmi.C_MESSAGE ='p_depa_18_group'
and
mmi.OPTION_CODE in (#promptmany('p_depa_code')#)
)
AND
A.CURR_DAY = TO_DATE(#prompt('p_indexdate')#,'YYYYMMDD')
AND
A.SUB_ORI_SUBJECT IN ('ZJ_ZJMXBG02','ZJ_ZJMXBI02')
) M1 Group by
M1.YY_TYPE
A.CURR_DAY要实现成当时系统日期-1
CURR_DAY仅作为查询条件,没查出来。过滤器没法引用