SELECT T .ticket_id, ROW_NUMBER () OVER ( PARTITION BY tt.ticket_id ORDER BY tt.ACT_START_TIME ) AS GROUP_ID FROM T_TICKET T LEFT JOIN T_TICKET_TASK tt ) ss WHERE ss. GROUP_ID = 1
这个问题困扰好久,mark下
SELECT T .ticket_id, ROW_NUMBER () OVER ( PARTITION BY tt.ticket_id ORDER BY tt.ACT_START_TIME ) AS GROUP_ID FROM T_TICKET T LEFT JOIN T_TICKET_TASK tt ) ss WHERE ss. GROUP_ID = 1
这个问题困扰好久,mark下