--指标：2500017
SELECT T.C_PORT_CODE,NVL(N_HLDMKV_LOCL,0) N_VALUE,
TO_CHAR(A.D_BIZ,'YYYY"年"MM"月"DD"日"') C_VALUE_CODE,T.C_PORT_CLS_CODE AS C_PORT_CLS_CODE,T.C_VALUE_NO AS C_VALUE_NO
FROM T_REPORT_RESULT T
LEFT JOIN (
SELECT A.D_BIZ,A.C_PORT_CODE,A.C_PORT_CLASS,A.N_HLDMKV_LOCL
FROM T_PORT_INDEX A
LEFT JOIN VB_PORT_BASEINFO P
ON P.C_PORT_CODE = A.C_PORT_CODE
WHERE A.C_PORT_CODE = 'SEN276'
AND A.D_BIZ = LEAST(TO_DATE('20230430', 'YYYYMMDD'),P.D_CLEAR)
AND A.C_IDX_CODE = 'ZCJZ'
AND A.C_PORT_CLASS <> 'NA'
) A ON A.C_PORT_CODE = T.C_PORT_CODE AND A.C_PORT_CLASS = T.C_PORT_CLS_CODE
WHERE T.N_DATE='20230430'
AND T.C_QUERY_ID='SEN276;smjj_yb_bz522'
AND T.C_PORT_CODE='SEN276'
AND T.N_SET_ID=2500016;
标签：CODE,VALUE,CLASS,BIZ,SEN276,UBS03I,PORT From： https://www.cnblogs.com/wugongben/p/17639568.html