解决方案 »
- 如何获取用户表
- Oracle数据库导入报错 ORA-39083 在线等。。
- oracle for update
- ******** oracle 有没有监听时间触发事件的功能?
- PROC数据库编程,怎么在提交SQL语句时加一个超时限制?
- 想存储500个汉字左右的信息,用什么字段好?
- 有了客户的license号,怎么才能在metalink.oracle.com注册成功呢?让输入CSI号,是否就是许可号呢?
- oracle9.2.0在p4机器上安装问题?
- 在客户端用plsqldevelop备份服务器端的oracle的数据库问题(在线等待
- Oracle Client 怎样通过SqlPlus 连接到Server
- timesten内存数据库:查询row_number排序后的结果不正确
- oracle日志
而且你说的日期段是指固定月的日期还是
一年365天的某个日期段??
selcet sum(trx_amt),
CASE trx_dt
when between '2014-06-10' and '2014-06-16' then '2014-06-16'
when between '2014-06-17' and '2014-06-23' then '2014-06-23'
END
from ac_trx_jnl
group by
CASE trx_dt
when between '2014-06-10' and '2014-06-16' then '2014-06-16'
when between '2014-06-17' and '2014-06-23' then '2014-06-23'
END
selcet sum(trx_amt),
CASE trx_dt
when between '2014-06-10' and '2014-06-16' then '2014-06-16'
when between '2014-06-17' and '2014-06-23' then '2014-06-23'
END
from ac_trx_jnl
group by
CASE trx_dt
when between '2014-06-10' and '2014-06-16' then '2014-06-16'
when between '2014-06-17' and '2014-06-23' then '2014-06-23'
END
你写的case when语法错误
它有两种方式
简单式语法:
case 字段 when 值 then 1 esle 0 end
搜索式语法:
case when 字段=值(大于等于小于这些条件) then 1 esle 0 end你的应该改成:
CASE
when trx_dt between '2014-06-10' and '2014-06-16' then '2014-06-16' esle ...
when trx_dt between '2014-06-17' and '2014-06-23' then '2014-06-23' else ...
END
sum(case when trx_dt between date'2014-5-1' and date'2014-5-2' then trx_amt end) num2,
from ac_tdl