我有一个表机智的用户。我想收集男孩和女孩,并显示他们的数量。我这样做:
SELECT COUNT(`is_male`) AS 'boys' FROM `users` WHERE `is_male` = 1 UNION (SELECT COUNT(`is_male`) AS 'girls' FROM `users` WHERE `is_male` = 0)
但是它以单列“ boys”显示结果,我如何以两列“ boys”和“ girls”显示一行?
只需使用条件聚合:
SELECT SUM(is_male = 1) AS boys,
SUM(is_male = 0) as girls
FROM users ;
笔记:
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句