select
'2011-12-23~2011-12-25' as DEALDATE,
'ALL' as USERID,
count(*) as HandledQty ,
sum(decode(RESULT,'Accept',1,0)) as AcceptQty ,
sum(decode(RESULT,'Reject',1,0)) as RejectQty
from
AF_OPERATOR_LOG
where
DEALDATE between ('2011-12-23','2011-12-25')
and
TASKTYPE=IQC
group by
DEALDATE, USERID
不知道我的这个SQL语句是否正确,或者错在哪里,希望高手帮帮忙啦,O(∩_∩)O谢谢
'2011-12-23~2011-12-25' as DEALDATE,
'ALL' as USERID,
count(*) as HandledQty ,
sum(decode(RESULT,'Accept',1,0)) as AcceptQty ,
sum(decode(RESULT,'Reject',1,0)) as RejectQty
from
AF_OPERATOR_LOG
where
DEALDATE between ('2011-12-23','2011-12-25')
and
TASKTYPE=IQC
group by
DEALDATE, USERID
不知道我的这个SQL语句是否正确,或者错在哪里,希望高手帮帮忙啦,O(∩_∩)O谢谢
解决方案 »
- Oracle 备份数据库报错?
- 存储过程转换,急求高手帮助!谢谢!!
- Oracle 事务嵌套[if(true)then insert1 end if; insert2]
- 使用日期当的问题
- 我用的是oracle10g_10.2.0版本,我现在学习的视频教程是oracle9i_9.2.0.1.0版本,能给我点经验和学习的建议吗?
- select语句的performance问题
- 求一个条件更新的SQL文
- 如何编写ORACLE返回记录的存储过程
- SQLSERVER2000数据库到ORACLE的数据传输问题?
- dbms_job包的问题 急!!!
- Oracle dbms_output.put 和dbms_output.put_line 的区别
- 关于sqldeveloper 连接oracle出现ora12505的奇怪问题
select
'2011-12-23~2011-12-25' as DEALDATE,
'ALL' as USERID,
count(*) as HandledQty ,
sum(decode(RESULT,'Accept',1,0)) as AcceptQty ,
sum(decode(RESULT,'Reject',1,0)) as RejectQty
from
AF_OPERATOR_LOG
where
DEALDATE between ('2011-12-23','2011-12-25')
and
TASKTYPE=IQC
;或者
select
'2011-12-23~2011-12-25' as DEALDATE,
'ALL' as USERID,
count(*) as HandledQty ,
sum(decode(RESULT,'Accept',1,0)) as AcceptQty ,
sum(decode(RESULT,'Reject',1,0)) as RejectQty
from
AF_OPERATOR_LOG
where
DEALDATE between ('2011-12-23','2011-12-25')
and
TASKTYPE=IQC
group by
'2011-12-23~2011-12-25', 'ALL'
dealdate是表中的一个字段,为date类型。
只能从语法上看一下,不保证逻辑上满足你的要求。select
'2011-12-23~2011-12-25' as MyDate,
'ALL' as USERID,
count(*) as HandledQty ,
sum(decode(RESULT,'Accept',1,0)) as AcceptQty ,
sum(decode(RESULT,'Reject',1,0)) as RejectQty
from
AF_OPERATOR_LOG
where
DEALDATE between to_date('2011-12-23', 'YYYY-MM-DD')
AND to_date('2011-12-25', 'YYYY-MM-DD')
AND TASKTYPE=IQC;
如果是字串的.就用下面.
select
'2011-12-23~2011-12-25' as MyDate,
'ALL' as USERID,
count(*) as HandledQty ,
sum(decode(RESULT,'Accept',1,0)) as AcceptQty ,
sum(decode(RESULT,'Reject',1,0)) as RejectQty
from
AF_OPERATOR_LOG
where
DEALDATE between to_date('2011-12-23', 'YYYY-MM-DD')
AND to_date('2011-12-25', 'YYYY-MM-DD')
AND TASKTYPE=IQC;select
'2011-12-23~2011-12-25' as MyDate,
'ALL' as USERID,
count(*) as HandledQty ,
sum(decode(RESULT,'Accept',1,0)) as AcceptQty ,
sum(decode(RESULT,'Reject',1,0)) as RejectQty
from
AF_OPERATOR_LOG
where
DEALDATE between '2011-12-23' AND '2011-12-25' AND TASKTYPE=IQC;