没看明白,我给你个例子,你看看是不是类似这种WITH tab AS(SELECT 1 id,'2012.1' cost_date FROM dual UNION allSELECT 2 ID,'2012.2' cost_date FROM dual UNION ALL SELECT 1 ID,'2012.4' cost_date FROM dual UNION ALLSELECT 1 id,'2012.12' cost_date FROM dual )SELECT id,col FROM(SELECT ID,cost_date||'~'||lead(cost_date) over(PARTITION BY I...
|