请问下。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的通话时间之和,我怎么查通话量是多少?
select count(1) from R_SU_E_bak t where TALKING_TIME<'30'
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'我是这样写的。可以统计,可是不知道对不对。请问下你count(1)是什么意思?
count(1)和count(*)一样,是所有条数。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')