SELECT
bt.GroupID as 'ID',
bt.EventStartTime as 'StartStartTime',
bt.EventEndTime as 'StartEndTime',
bt.TotalEventDuration as 'StartDuration',
pt.EventStartTime as 'ProcessStartTime',
pt.EventEndTime as 'ProcessEndTime',
pt.TotalEventDuration as 'ProcessDuration',
st.EventStartTime as 'StopStartTime',
st.EventEndTime as 'StopEndTime',
st.TotalEventDuration as 'StopDuration'
FROM
PROCESS_LOG bt
LEFT JOIN PROCESS_LOG pt ON
bt.GroupID = pt.GroupID
LEFT JOIN PROCESS_LOG st ON
bt.GroupID = st.GroupID
WHERE
bt.Event = 'Start'
AND pt.Event = 'Process'
AND st.Event = 'Stop'
1 回答
使用纯SQL我认为这是您正在寻找的查询
我假设你必须开始以便处理和/或停止,这似乎不切实际 . 我们的想法是连接表3次以提取每个事件的信息,GroupID是关联它们的“ Binders ” .