创建视图 例子
来源:互联网 发布:qq群关系数据库在线 编辑:程序博客网 时间:2024/06/06 00:16
create or replace view v_td_allgg as
select id,boutname,startdate,enddate,type,hydm from (
select zb.ggid as id, zb.promc as boutname, zb.gmbsjs as startdate,zb.gmbsks as enddate,1 as type,null as hydm from td_zbgg zb where zb.ggzt=2
union all
select qi.fphm as id ,qi.title as boutname ,qi.date1 as startdate ,qi.date0 as enddate,2 as type,qi.hydms as hydm from Td_Query_Info qi where qi.STATUS =100 and qi.flag06 = 1
union all
select td.boutid as id, td.boutname ,td.startdate ,td.enddate , 3 as type,null as hydm from TD_TD_BOUT td where td.STATUS in ('30','40')
union all select ac.boutid as id, ac.boutname ,ac.startdate ,ac.enddate, 4 as type,null as hydm from TD_AC_BOUT ac where ac.STATUS in ('30','40')
) order by startdate desc;
select id,boutname,startdate,enddate,type,hydm from (
select zb.ggid as id, zb.promc as boutname, zb.gmbsjs as startdate,zb.gmbsks as enddate,1 as type,null as hydm from td_zbgg zb where zb.ggzt=2
union all
select qi.fphm as id ,qi.title as boutname ,qi.date1 as startdate ,qi.date0 as enddate,2 as type,qi.hydms as hydm from Td_Query_Info qi where qi.STATUS =100 and qi.flag06 = 1
union all
select td.boutid as id, td.boutname ,td.startdate ,td.enddate , 3 as type,null as hydm from TD_TD_BOUT td where td.STATUS in ('30','40')
union all select ac.boutid as id, ac.boutname ,ac.startdate ,ac.enddate, 4 as type,null as hydm from TD_AC_BOUT ac where ac.STATUS in ('30','40')
) order by startdate desc;
0 0
- 创建物化视图例子
- 创建视图 例子
- 物化视图详解--介绍、创建方法、例子
- 物化视图详解--介绍、创建方法、例子
- 物化视图详解--介绍、创建方法、例子
- Scripts:创建物化视图例子example_create_materialized_view.sql
- 写sql语句创建视图的一个例子
- 创建视图
- 创建视图
- 创建视图
- 创建视图
- 创建视图
- 创建视图
- 创建视图
- 视图创建
- 创建视图
- 创建视图
- 创建视图
- 通过金矿模型介绍动态规划
- Android自定义RatingBar(评分控件)
- 唯品会测试专员实习生笔试
- Python正则表达式指南
- 汤力嘉-秒拍-10秒拍大片!
- 创建视图 例子
- ReportStudio进阶教程(八) - 引入JQuery
- Java实现二维码QRCode的编码和解码
- Arcgis for Javascript API下类似于百度搜索A、B、C、D marker的实现方式
- 国内最全最详细的hadoop2.2.0集群的MapReduce的最简单配置
- android NFC学习笔记(一)
- 解决广播风暴
- ORA-00845: MEMORY_TARGET not supported on this system报错解决
- oracle-索引使用 问题解答