以统计每个班级男生女生数量以及总人数为例,列名
sex: 1:男生 2:女生
class:班级(根据班级分组)
SELECT
COUNT(CASE WHEN (sex = 1) THEN class END) AS 男生 ,
COUNT(CASE WHEN (sex = 2) THEN class END) AS 女生,
COUNT(id) AS 总人数
FROM sp_student GROUP BY class
以统计每个班级男生女生数量以及总人数为例,列名
sex: 1:男生 2:女生
class:班级(根据班级分组)
SELECT
COUNT(CASE WHEN (sex = 1) THEN class END) AS 男生 ,
COUNT(CASE WHEN (sex = 2) THEN class END) AS 女生,
COUNT(id) AS 总人数
FROM sp_student GROUP BY class