自己写的多表联合查询，统计，行变列

最新推荐文章于 2024-01-31 22:18:26 发布

cmlxiaogeaaa

最新推荐文章于 2024-01-31 22:18:26 发布

阅读量906

点赞数

分类专栏： C++ builder

本文链接：https://blog.csdn.net/cmlxiaogeaaa/article/details/43016255

版权

C++ builder 专栏收录该内容

43 篇文章 0 订阅

订阅专栏




  select trycord.*,b.*  from 

(select top 2 * from RemoteTryRecord where  id > 

     ( select isnull(max(id),0) from 

            (select top 2 id from RemoteTryRecord where  data between '2014-12-03 00:00:00' and '2016-01-01 00:00:00'    order by id  )  c 

     ) 

order by id )as trycord 

left join 

(select count ( distinct useaddress)as addresscount  ,count (*) as  allcount , UseOperateId ,sum (case when ControlResult=1 then 1 else 0 end) as SuccessCount,sum (case when ControlResult=2 then 1 else 0 end) as failecount
   	from 
		(select  distinct 操作票表.fzaddr as fzaddr,操作票表.nodeaddr,操作票表.OperateId as UseOperateId,设备表.address as useaddress ,操作票表.ControlResult as ControlResult
		from 操作票表,设备表 where 操作票表.fzaddr = 设备表.fzaddr and 操作票表.nodeaddr = 设备表.nodeaddr
		) as a 
    	GROUP BY UseOperateId  ) b


 on trycord.OperateId=b.UseOperateId

自己写的多表联合查询