行合并:
WITH A AS (
SELECT 1123 ID,'2008-9-19' DAY,'9:7:47' TIME FROM DUAL UNION
SELECT 1123 ID,'2008-9-19' DAY,'19:7:47' TIME FROM DUAL UNION
SELECT 1123 ID,'2008-9-19' DAY,'13:7:47' TIME FROM DUAL UNION
SELECT 1123 ID,'2008-9-19' DAY,'12:7:47' TIME FROM DUAL )
select ID,DAY,WMSYS.WM_CONCAT(TIME) TIME FROM A GROUP BY ID,DAY
我的例子:
select t.actionname,WMSYS.WM_CONCAT(t.action) ACTION ,WMSYS.WM_CONCAT(t.id) ID
from FLOW_ACTION t group by t.actionname ,t.columnid
Oracle相同的列不同的行合并
最新推荐文章于 2023-08-04 16:57:57 发布