SELECT a.c_port_code122-526互联

SELECT a.c_port_code,
a.d_aststat,
ZCJZ1,
ZCJZ2
FROM
(SELECT a.c_port_code,
a.d_aststat,
A.N_PORT_MV ZCJZ1,
a.N_PORT_COST ZCJZ2,ROW_NUMBER() OVER (PARTITION BY a.c_port_code ORDER BY a.d_aststat DESC) RN
FROM t_r_fr_aststat a
where (C_PORT_CODE = 'SSD770')
and a.d_aststat IN (GETDAY_HDAY('CN',TRUNC(date'2023-08-23','MM'),-1,'W'),
GETDAY_HDAY('CN',TRUNC(ADD_MONTHS(date'2023-08-23',-1),'MM'),-1,'W'),
GETDAY_HDAY('CN',TRUNC(ADD_MONTHS(date'2023-08-23',-2),'MM'),-1,'W')
)
and a.c_key_code = 'ZCJZ'
and instr(a.c_km_code, '_') = 0)A
WHERE A.RN = 1