如何将查询结果横向合并,找了很多帖子,最后…
最后功夫不负有心人,被窝找到啦,特意分享给大家,好用了记得给点赞投币一键三连O(∩_∩)O哈哈~
SELECT t.工件台,SUM(t.数量1) 差异数, SUM(t.数量2) 总数,CONCAT(TRUNCATE(SUM(t.数量1)/SUM(t.数量2)*100,2),'%') 占比 FROM
(SELECT t1.inductionid 工件台,COUNT(DISTINCT t1.barcode) 数量1,0 AS 数量2 FROM t_yto_sealmail t1
WHERE indtime >'2021-3-17 19' AND weight='0.02' AND bagid <>'' GROUP BY t1.inductionid
UNION ALL
SELECT t2.inductionid 工件台,0 AS 数量1,COUNT(DISTINCT t2.barcode) 数量2 FROM t_yto_sealmail t2
WHERE indtime >'2021-3-17 19' AND bagid <>'' GROUP BY t2.inductionid) t
GROUP BY t.`工件台`;
语句的两个关键处:1、0 AS 新字段 ;2、UNION ALL 连接后 使用SUM函数
详细可参考: