说明:survey_consumer是表名,sex是表中性别字段,储存的是数字(0:女,1:男,2:未知)
SELECT COUNT(*) num,CASE sex WHEN '1' THEN '男' WHEN '0' THEN '女' WHEN '2'
THEN '未知' END AS name FROM survey_consumer GROUP BY sex
说明:survey_consumer是表名,sex是表中性别字段,储存的是数字(0:女,1:男,2:未知)
SELECT COUNT(*) num,CASE sex WHEN '1' THEN '男' WHEN '0' THEN '女' WHEN '2'
THEN '未知' END AS name FROM survey_consumer GROUP BY sex