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下