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下
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M