1 select count(*) as numOfTotal,
2 sum(case when t.[gender]=\'male\' then 1 else 0 end) as numOfMale , --男生人数
3 sum(case when t.[gender]=\'female\' then 1 else 0 end) numOfFemale, --女生人数
4 sum(case when t.[gender]=\'male\' then 1 else 0 end)*1.0/count(*) as percentOfMale,
5 sum(case when t.[gender]=\'female\' then 1 else 0 end)*1.0/count(*) as perscentOfFemale
6 from
7 (SELECT a.[userid],a.[module],a.[amount],b.[name],b.[gender]
8   FROM [PracticeSQL].[dbo].[module] a inner join [PracticeSQL].[dbo].[user] b
9   on a.[userid]=b.[userid]) t

 

输出结果：

numOfTotal numOfMale numOfFemale percentOfMale perscentOfFemale
18 14 4 0.777777777777 0.222222222222

 

参考：http://blog.csdn.net/guoxingege/article/details/48054815

版权声明：本文为ttaobupt原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/ttaobupt/archive/2004/01/13/7132745.html