摘要:
CREATE OR REPLACE VIEW V_IMD_JC_BAD_WEATHER ASSELECTEVENT_ID,TRANSLATE (LTRIM (text, '/'), '*/', '*,') BWS_SEC_ID,TRANSLATE (LTRIM (mse_name, '/'), '*/', '*,') MSE_NAMEFROM (SELECT ROW_NUMBER () OVER (PARTITION BY EVENT_ID ORDER BY EVENT_ID,lvl DESC) r 阅读全文