SQL查询性别字段为0显示男,1显示女,并输出对应数量
SELECT
CASE
WHEN(Sex=0)
THEN ‘男’
WHEN(Sex=1)
THEN ‘女’
ELSE ‘X’
END AS Gender,
COUNT(1) AS CNT
FROM student
GROUP BY Sex
SELECT
CASE
WHEN(Sex=0)
THEN ‘男’
WHEN(Sex=1)
THEN ‘女’
ELSE ‘X’
END AS Gender,
COUNT(1) AS CNT
FROM student
GROUP BY Sex