简单的问题,就用简洁的语言来解释,欢迎大家一起交流!
首先,贴出这个SQL语句:
SELECT
SUM(case when sex=1 then '男' else ‘其他’ end )as '男生' (1)
SUM(case when sex =2 then ‘女’ else ‘其他’ end )as'女生' (2)
FROM table
SELECT
SUM(case when sex=1 then '男' else ‘其他’ end )as '男生' (1)
SUM(case when sex =2 then ‘女’ else ‘其他’ end )as'女生' (2)
FROM table