22,301
社区成员




SELECT
CONVERT(float,
CONVERT(decimal(18,4),CONVERT(decimal(18,4),92984)/CONVERT(decimal(18,4),157888))
)*100
select count(*)as 总数,
sum(case when sex=0 then 1 else 0 end) 男人数,
cast(100*(cast(1.0*sum(case when sex=0 then 1 else 0 end)/count(*) as decimal(18,2)))as varchar(20))+'%' 男占比例
from cj_yonghu