请问下。select sum(TALKING_TIME) from R_SU_E_bak t where
start_time>to_date('2011-11-01 00:00:00','yyyy-MM-dd hh24:mi:ss') and start_time<to_date('2011-11-30 23:59:59','yyyy-MM-dd hh24:mi:ss') and
and TARGET='ACD4955' and TALKING_TIME<'30'这句话是查TALKING_TIME的通话时间之和,我怎么查通话量是多少?
start_time>to_date('2011-11-01 00:00:00','yyyy-MM-dd hh24:mi:ss') and start_time<to_date('2011-11-30 23:59:59','yyyy-MM-dd hh24:mi:ss') and
and TARGET='ACD4955' and TALKING_TIME<'30'这句话是查TALKING_TIME的通话时间之和,我怎么查通话量是多少?
解决方案 »
- 存储过程这么写不对吗?
- sql server 可不可以联机?
- 数据库中表的大小是多少?
- 真的要疯了,请大家帮个忙,关于sql2000
- 关于独占的问题的
- VS2008+SQLServer2005怎么错误提示都是韩语???
- 哪里有sql sever 6.5 下载啊?急!
- 高手进!!!求大量数据得插入,更新操作.如何降低存储过程得开销,内存!!!比如说100万条!!!给我解决了,我给大家说一个比较简单实现BOM的库设
- Befresh你好:你的E-MAIL收到,谢谢你的帮助!
- 怎样提取数据库中不同表中各种日期错误的行? 急!
- sql中有“分支语句”吗?比如 switch 对几种并行的情况分别处理?
- XP专业版SP3系统安装SQL2008出错,有图有真相
select sum(TALKING_TIME),COUNT(1) AS 总条数 from R_SU_E_bak t
where
start_time>to_date('2011-11-01 00:00:00','yyyy-MM-dd hh24:mi:ss') and
start_time<to_date('2011-11-30 23:59:59','yyyy-MM-dd hh24:mi:ss') and
and TARGET='ACD4955' and TALKING_TIME<'30'to_date 是Oracle的吧?
select sum(TALKING_TIME) 时长,count(1) 通话量 from R_SU_E_bak t where
start_time>to_date('2011-11-01 00:00:00','yyyy-MM-dd hh24:mi:ss') and start_time<to_date('2011-11-30 23:59:59','yyyy-MM-dd hh24:mi:ss') and
and TARGET='ACD4955' and TALKING_TIME<'30'
select sum(TALKING_TIME) 总通话时间,COUNT(1) 总通话量 from R_SU_E_bak
where TARGET='ACD4955' and TALKING_TIME<'30' and
start_time>to_date('2011-11-01 00:00:00','yyyy-MM-dd hh24:mi:ss') and
start_time<to_date('2011-11-30 23:59:59','yyyy-MM-dd hh24:mi:ss')