sql多表分组查询

最新推荐文章于 2024-07-13 17:19:40 发布

zhangqihua0

最新推荐文章于 2024-07-13 17:19:40 发布

阅读量738

点赞数

分类专栏： sql server

本文链接：https://blog.csdn.net/zhangqihua0/article/details/8182195

版权

sql server 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

select * from
(
select   t0=CONVERT(VARCHAR(10),[TimeStamp],120)
from table0 S
               INNER JOIN ACDGroupMember M on
               S.LoginID=M.AgentID
               WHERE M.ACDGroupID=10016 AND S.TimeStamp BETWEEN '2012-10-2' AND '2012-11-2'
               group by CONVERT(VARCHAR(10),[TimeStamp],120)
      )a
left join
       (
       select t1= COUNT(M.AgentID),t2=CONVERT(VARCHAR(10),[TimeStamp],120)
from table1 S
               INNER JOIN ACDGroupMember M on
               S.LoginID=M.AgentID
               WHERE M.ACDGroupID=10016 AND S.TimeStamp BETWEEN '2012-10-2' AND '2012-11-2'
               group by CONVERT(VARCHAR(10),[TimeStamp],120)
       )b on t0=t2