主要应用函数 sum, case when
例:求user表里男人和女人的数量
SELECT count(id), SUM(CASE sex WHEN '男' THEN 1 ELSE 0 END) as type1,SUM(CASE sex WHEN '女' THEN 1 ELSE 0 END) as type2 FROM user ;
主要应用函数 sum, case when
例:求user表里男人和女人的数量
SELECT count(id), SUM(CASE sex WHEN '男' THEN 1 ELSE 0 END) as type1,SUM(CASE sex WHEN '女' THEN 1 ELSE 0 END) as type2 FROM user ;