DB2 With语句递归

WITH T1 (T11
    , T22
    , T33
    , T44) AS
    (SELECT TASKID
         , REPLY
         , ROWNUMBER () OVER (PARTITION BY TASKID)
         , ROWNUMBER () OVER (PARTITION BY TASKID) AS T4
     FROM RT_CALLTASKRECDT)
    , T3 (S1
    , S2
    , S3
    , S4) AS
    (SELECT T11
         , CAST (T22 AS VARCHAR (100))
         , T33
         , T44
     FROM T1
     WHERE T33 = 1 AND T44 = 1 UNION ALL
    SELECT A.S1
        , CAST (A.S2 || ',' || B.T22 AS VARCHAR (100))
        , A.S3 + 1
        , A.S4
    FROM T3 A
        , T1 B
    WHERE A.S1 = B.T11 AND A.S3 = B.T44 - 1)
SELECT S1
    , S2
FROM T3 X
WHERE X.S3 = (SELECT MAX (S3)
              FROM T3 Y
              WHERE X.S1 = Y.S1);

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值