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
' ;
为何上面的group by失效?
--表tmp20sAAA 两字段
tRpt_tmp20sAAA
caid wtforagent
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
' ;
为何上面的group by失效?
--表tmp20sAAA 两字段
tRpt_tmp20sAAA
caid wtforagent
请指教……
group by callid