select sum(case when sex='男' then 1 else 0 end ) 男生人数,sum(case when sex='女' then 1 else 0 end ) 女生人数
from user;
https://blog.csdn.net/csulfy/article/details/54916402
select sum(case when sex='男' then 1 else 0 end ) 男生人数,sum(case when sex='女' then 1 else 0 end ) 女生人数
from user;
https://blog.csdn.net/csulfy/article/details/54916402