17,377
社区成员
发帖
与我相关
我的任务
分享
sqlstrInsertTb:= '
insert into tmp20sAAA select caid,sum(timeend-timebegin)*86400
from
(
select * from '||sTableName||'
where timeend >= to_date('''||i_sBeginTime||''',''YYYYMMDDHH24MISS'')
and timebegin < to_date('''||i_sEndTime||''',''YYYYMMDDHH24MISS'')
and caTYPE in (0,5,13)
)
group by callid
' ;
sqlstrt20:= '
select count(*) from tmp20sAAA where wtforagent <= 20
' ;
--表tmp20sAAA 两字段
tRpt_tmp20sAAA
caid wtforagent
select caid,
group by callid