文章目录 1. 条件语句2. GROUP BY 它们两有什么关系? ——行列转换的关系 1. 条件语句 SELECT SUM(IF(s_sex = "男",1 ,0)) cnt_male, SUM(IF(s_sex = "女",1, 0)) cnt_female FROM Student 2. GROUP BY 如果并不需要知道所求字段对应的对象则可以直接使用 GROUP BY: SELECT COUNT(s_id) FROM Student GROUP BY s_sex