'组合代码'

SELECT a.c_sec_var_mx,sum(n_hldmkv_locl)
FROM T_FINANCIAL_VAL A
WHERE A.C_PA_CODE in ('ZQTZ_CB')
AND A.C_PORT_CODE = '组合代码'
AND A.D_BIZ = TO_DATE('20230331', 'YYYYMMDD')
group by a.c_sec_var_mx

SELECT a.c_sec_var_mx,sum(n_hldmkv_locl)
FROM T_FINANCIAL_VAL A
WHERE A.C_PA_CODE in ('ZQTZ_CB','YSLX_ZQ')
AND A.C_PORT_CODE = '组合代码'
AND A.D_BIZ = TO_DATE('20230331', 'YYYYMMDD')
group by a.c_sec_var_mx