SELECT
A5.processName AS 名称
,A0.name AS 审批节点
,A2.role AS 角色
,A3.fullName AS 全名
,A5.eventList AS 事件,
CONVERT(varchar,A2.createStampA2,120) 创建,
CONVERT(varchar,A2.modifyStampA2,120) 修改,
DATEDIFF(DAY,A2.createStampA2 ,A2.modifyStampA2) as 耗时天数
FROM wc.WfVotingEventAudit A5
left join wc.WorkItem A2 on A5.idA3B6 = A2.idA2A2
LEFT JOIN wc.WTUser A3 ON A2.idA3A2ownership = A3.idA2A2
left join
(SELECT
A0.idA3parentProcessRef
,A0.idA2A2
,A0.name
FROM
wc.WfAssignedActivity A0
UNION ALL
SELECT
A0.idA3parentProcessRef
,A0.idA2A2
,A0.name
FROM
wc.WfAdHocActivity A0)A0 ON A2.idA3A4 = A0.idA2A2
LEFT JOIN wc.WfProcess A1 ON A0.idA3parentProcessRef = A1.idA2A2
WHERE A5.processName like '%0000000825%'
把问题描述准备,把你现在的状况和实现的结果放出来,再把你数据库的字段截图
关键字:行转列
oracle行转列使用pivot函数,列转行使用ws_concat函数