DB2 With语句递归
2024-08-31 06:04:11
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);
最新文章
- 套接字IO超时设置和使用select实现超时管理
- 4.用文本编辑器输入课堂上练习的Hello.java,并在JDK环境下编译和运行。请将程序编译、运行的结果截图,填入下框中。
- Jqgrid入门-Jqgrid列数据拖动(七)
- Tuple元组
- Quartus中例化工程
- CloudStack核心类ApiServlet、ApiServer、ApiDispatcher、GenericDaoBase源码分析
- IOS的Application以及IOS目录的介绍
- Spring MVC 文件下载时候 发现IE不支持
- Centos7下安装php7
- apply,all,bind的区别
- 如何合理封装你的轮子、飞机、大炮(以封装OkHttp为例)
- OpenCV imread读取jpg图像的一个大坑
- Python交互K线工具 K线核心功能+指标切换
- 2019.03.28 bzoj3594: [Scoi2014]方伯伯的玉米田(二维bit优化dp)
- 【转】实现Nginx代理WSS协议
- [THUWC2017]在美妙的数学王国中畅游
- DevExpress11、TreeList
- Kafka:ZK+Kafka+Spark Streaming集群环境搭建(二十八):kafka0.10.1 内置性能测试API用法示例
- python基础---->;python的使用(七)
- cmake编译参数