摘要: 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 阅读全文
posted @ 2013-12-13 10:08 小水阿哥 阅读(894) 评论(0) 推荐(0) 编辑