WHEN T6.START_END_DIFF <= 20 THEN
来源:互联网 发布:网络彩票开售 编辑:程序博客网 时间:2024/03/28 19:33
小心case when 里面的判断
SELECT T7.XXC_TYPE,
T7.EVENT_ID,DECODE(T7.DIS_END, 0, 1, 0) COL0,
DECODE(T7.DIS_END, 1, 1, 0) COL1,
DECODE(T7.DIS_END, 2, 1, 0) COL2,
DECODE(T7.DIS_END, 3, 1, 0) COL3,
DECODE(T7.DIS_END, 4, 1, 0) COL4,
DECODE(T7.DIS_END, 5, 1, 0) COL5,
DECODE(T7.DIS_END, 6, 1, 0) COL6
FROM (SELECT T6.XXC_TYPE,
T6.EVENT_ID,
CASE
WHEN T6.START_END_DIFF > 0 AND
T6.START_END_DIFF <= 10 THEN
0
WHEN T6.START_END_DIFF <= 20 THEN
1
WHEN T6.START_END_DIFF <= 30 THEN
2
WHEN T6.START_END_DIFF <= 40 THEN
3
WHEN T6.START_END_DIFF <= 50 THEN
4
WHEN T6.START_END_DIFF <= 60 THEN
5
ELSE
6
END DIS_END
FROM (SELECT T5.XXC_TYPE,
T4.EVENT_ID,
ABS((T3.OUTAGE_START_TIME -
T4.OUTAGE_START_TIME) * 24 * 60) START_TIME_DIFF,
ABS((T3.OUTAGE_END_TIME - T4.OUTAGE_END_TIME) * 24 * 60) START_END_DIFF
FROM DMS_CRC_EVENT_RIMS_TRANS T3,
DMS_CRC_EVENT_SD_TRANS T4,
(SELECT T1.EVENT_ID RIMS_EVENT_ID,
T2.EVENT_ID SD_EVENT_ID,
T1.XXC_TYPE
FROM DMS_CRC_EVENT_RIMS T1,
DMS_CRC_EVENT_SD T2
WHERE T1.XXC_EVENT_ID = T2.OUTAGE_ID AND
T1.XXC_TYPE = T2.XXC_TYPE
AND T1.XXC_TYPE IN (2)
AND t2.event_id=909069
AND T1.OUTAGE_START_TIME BETWEEN TO_DATE('2013-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') AND
TO_DATE('2013-11-30 23:59:59', 'YYYY-MM-DD HH24:MI:SS')) T5
WHERE T3.TRANS_CODE = T4.TRANS_CODE AND
T3.EVENT_ID = T5.RIMS_EVENT_ID
AND T4.EVENT_ID = T5.SD_EVENT_ID
) T6) T7
GROUP BY T7.XXC_TYPE, T7.EVENT_ID, T7.DIS_END
- WHEN T6.START_END_DIFF <= 20 THEN
- case when then else
- mssql ,case ,when,then
- case when then else
- case when then end
- CASE when then
- case when then
- sql --case when then
- case when then else
- case..when..then
- case when then
- case when then end
- CASE-WHEN-THEN
- sql case when then
- case when then else
- case when..then
- case when then
- oracle case when then
- struts2 的配置文件DTD
- Python基础08 面向对象的基本概念
- ubuntu12.04+nginx+fastcg+php5+mysql配置
- hdu-1197-Specialized Four-Digit Numbers
- 将java源码打包成可运行的jar
- WHEN T6.START_END_DIFF <= 20 THEN
- 反序数
- Qt安装—搭建VS2008+QT开发环境
- Web开源测试工具—Selenium介绍(1)
- 5.9 fread和fwrite函数-二进制I/O
- 多关键字排序的方法
- 星号图A
- ibatis sql_Map中出现异常:Cause: java.lang.RuntimeException: JavaBeansDataExchange could not instantiate..
- 3.8 《硬啃设计模式》 第17章 结构型设计模式小结