查询表获得男女数据的统计人数
SELECT
COUNT(*) VALUE,CASE `sex` WHEN '1' THEN '男' WHEN '2' THEN '女' END AS NAME
FROM
t_member m GROUP BY m.sex;
-- t_member 为表名
查询表获得男女数据的统计人数
SELECT
COUNT(*) VALUE,CASE `sex` WHEN '1' THEN '男' WHEN '2' THEN '女' END AS NAME
FROM
t_member m GROUP BY m.sex;
-- t_member 为表名