今天写了一句SQL 大致是这样:
select count(case when sex=1 then 1 else 0 end)as ‘男’,count(case when sex=2 then 1 else 0 end) as ‘女’ from demo
得出结果总是 总数(男女之和如count(*)) 后来才发现 count(0) 与 count(1) 并无区别
更改后的sql:
select count(case when sex=1 then 1 end) as '男',count(case when sex=2 then 1 end) as '女' from demo