将结果集插入另一个表中

 

将结果集插入另一个表中

insert into rep_agentworksum (DateTime,AgentName ,DayWorkSum , DayWork )
SELECT  DateTime,AgentName  ,Count(SessionId)as DayWorkSum ,1 as DayWork  FROM  cti_record WHERE Date ='2012-03-04' and AgentName in (1006,1013 )
group by AgentName

 

posted @ 2021-06-26 10:25  海乐学习  阅读(40)  评论(0)  编辑  收藏  举报