需求:查询数据库获取性别,所占个数及其所占比例
select (case when sex=0 then '女' else '男' end) name,
count(id) value,
count(id)/(select count(id) from t_member) proportion
from t_member
group by sex
需求:查询数据库获取性别,所占个数及其所占比例
select (case when sex=0 then '女' else '男' end) name,
count(id) value,
count(id)/(select count(id) from t_member) proportion
from t_member
group by sex