ORACLE将连续或不连续月份合并sql怎么写,要求不通过存储过程实现_百度...答:ALLSELECT 'B', '2018-05' FROM dual)SELECT col1,to_char(wm_concat(cat)) FROM (SELECT DISTINCT col1,MIN(col2)OVER(PARTITION BY col1,flg1)||'至'||Max(col2)OVER(PARTITION BY col1,flg1) catFROM(SELECT COL1,COL2,CASE WHEN SUBSTR(COL2,6) - LAG(SUBSTR(COL2,6)...