sql语句如下:
select
CUTOFFDAY as 'cutoffday',
sum(case when RESP_CODE='2008' then 1 end) as '2008',
sum(case when RESP_CODE='2104' then 1 end) as '2104'
from wzx
group by CUTOFFDAY为什么一直报FROM keyword not found where expected错误
求助各位高手,非常感谢!
select
CUTOFFDAY as 'cutoffday',
sum(case when RESP_CODE='2008' then 1 end) as '2008',
sum(case when RESP_CODE='2104' then 1 end) as '2104'
from wzx
group by CUTOFFDAY为什么一直报FROM keyword not found where expected错误
求助各位高手,非常感谢!
解决方案 »
- 请教 两个record的比较
- oracle.ldap.admin.common.SaveChangeException是什么问题
- 请教SQL
- 新手问 timesten 与 oracle 基本工作原理是怎么的
- oracle 遇到权限问题,疑惑
- Oracle中spool导出太慢,请问有更快的导出成格式化文本的方式吗?
- 请高手指点~
- 关于日期格式的问题!急啊!
- 为什么用JDBC访问oracle时说找不到packet oracle.jdnbc.*
- 在Window客户机下访问linux下的Oracle817服务器?
- 被360害惨了!360的木马工具把oracle.exe的自动启动给关闭了。怎么设置开机自动启动啊?
- 请大虾们帮忙看看这是什么意思?
SELECT CUTOFFDAY CUTOFFDAY,
SUM(CASE
WHEN RESP_CODE = '2008' THEN
1
END) A1,
SUM(CASE
WHEN RESP_CODE = '2104' THEN
1
END) A2
FROM WZX
GROUP BY CUTOFFDAY
CUTOFFDAY as 'cutoffday',
sum(case when RESP_CODE='2008' then 1 end) as '2008',
sum(case when RESP_CODE='2104' then 1 end) as '2104'
from wzx
group by CUTOFFDAY ,sum(case when RESP_CODE='2008' then 1 end),sum(case when RESP_CODE='2104' then 1 end)
CUTOFFDAY as 'cutoffday',
sum(case when RESP_CODE='2008' then 1 end) as '2008',
sum(case when RESP_CODE='2104' then 1 end) as '2104'
from wzx
group by CUTOFFDAY ,
case when RESP_CODE='2008' then 1 end,
case when RESP_CODE='2104' then 1 end