我的英语不是很好,但是我试图解释自己的意思。我需要建议。我正在从一个表中选择每个字段的值的总和。和我的查询看起来像这样:
SELECT * FROM
(
SELECT SUM(Clicks) AS sales , 'sales' as type
FROM ClicksPerDay
WHERE BannerID = 3456
UNION
SELECT SUM(Clicks) AS rent, 'rents' as type
FROM ClicksPerDay
WHERE BannerID = 3457
) total
我的输出是:
sales | type
23 | rents
26 | sales
我需要这样:
sales | rents
26 | 23
请尝试以下方法:
SELECT
SUM( IF(BannerId = 3456, Clicks, 0) ) AS sales,
SUM( IF(BannerId = 3457, Clicks, 0) ) AS rents
FROM ClicksPerDay
WHERE BannerID IN (3456, 3457)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句