Oracle将查询的结果放入一张自定义表中并再查询数据
作者:whsnow 时间:2024-01-24 18:23:56
如下的实际例子代码可以将查询的结果放入到一张自定义表中,同时可以再从这个自定义的表中查询数据:
with AA as
(SELECT TICKETNUMBER, TICKETTYPE, VERSIONNUMBER, STAGENAME, DTANALYZED,
GISPROCESSID, PROCESSSTATUS, DTRECEIVED, USERID, USERNAME, FIRSTNAME,
LASTNAME, NUMBEROFDAYS
FROM REPORT_PERFORMANCEOFANALYZER
WHERE (DTANALYZED IS NULL)
UNION ALL
SELECT TICKETNUMBER, TICKETTYPE, VERSIONNUMBER, STAGENAME, DTANALYZED,
GISPROCESSID, PROCESSSTATUS, DTRECEIVED, USERID, USERNAME, FIRSTNAME,
LASTNAME, NUMBEROFDAYS
FROM REPORT_PERFORMANCEOFANALYZER REPORT_PERFORMANCEOFANALYZER_1)
SELECT TICKETNUMBER, TICKETTYPE, VERSIONNUMBER, STAGENAME, DTANALYZED,
GISPROCESSID, PROCESSSTATUS, DTRECEIVED, USERID, USERNAME, FIRSTNAME,
LASTNAME, NUMBEROFDAYS,
(SELECT COUNT(GISPROCESSID) AS COUNTTICKETS FROM AA) COUNTTICKETS
FROM AA
ORDER BY USERNAME;
标签:查询结果,自定义表
![](/images/zang.png)
![](/images/jiucuo.png)
猜你喜欢
详解nodejs express下使用redis管理session
2024-05-11 09:51:40
在JavaScript中对HTML进行反转义详解
2024-05-02 16:21:19
Oracle 数据表分区的策略
2010-07-21 13:30:00
XMLHttp ASP远程获取网页内容代码
2011-04-10 10:41:00
TensorFlow2.0:张量的合并与分割实例
2022-12-02 13:44:49
MySQL 百万级分页优化(Mysql千万级快速分页)
2024-01-22 02:43:26
asp三天学好ADO对象之第三天
2008-10-09 12:53:00
关于Python中的编码规范
2021-11-07 02:38:02
js 原生判断内容区域是否滚动到底部的实例代码
2024-04-22 22:41:45
将ASP记录集输出成n列的表格形式显示的方法
2011-04-08 10:51:00
Python3+selenium实现cookie免密登录的示例代码
2023-01-31 15:43:09
![](https://img.aspxhome.com/file/2023/3/124643_0s.png)
mysql installer community 5.7.16安装详细教程
2024-01-17 04:55:04
![](https://img.aspxhome.com/file/2023/1/115571_0s.png)
简单好用的PHP分页类
2023-11-22 09:32:39
![](https://img.aspxhome.com/file/2023/6/111676_0s.jpg)
jupyter notebook实现显示行号
2022-11-20 03:51:40
![](https://img.aspxhome.com/file/2023/6/103616_0s.jpg)
微软建议的ASP性能优化28条守则(6)
2008-02-29 11:43:00
python爬虫中的url下载器用法详解
2022-06-28 01:09:21
Webpack 实现 Node.js 代码热替换
2024-05-13 10:04:14
Go定时器cron的使用详解
2024-04-28 10:47:43
基于python神经卷积网络的人脸识别
2023-11-03 17:37:17
![](https://img.aspxhome.com/file/2023/6/64356_0s.png)
基于Python实现新年倒计时
2022-02-14 08:41:59
![](https://img.aspxhome.com/file/2023/2/77702_0s.gif)