mysql表查询出性别列男和女的总人数为1行2列横排展示sql语句,如:
男 女
10 50
以下是SQL:
SELECT
SUM(CASE WHEN sex = '男' THEN 1 ELSE 0 END) AS 男,
SUM(CASE WHEN sex = '女' THEN 1 ELSE 0 END) AS 女
FROM
items;
表结构类似:
CREATE TABLE `items` (
`id` int(11) unsigned zerofill NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT '0',
`description` varchar(255) DEFAULT '0',
`sex` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=1863 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;