sql server 计算男女比例百分比

最新推荐文章于 2024-08-15 10:29:37 发布

信息屋

最新推荐文章于 2024-08-15 10:29:37 发布

阅读量2.3w

点赞数 5

分类专栏： sql server 文章标签： sql server

本文链接：https://blog.csdn.net/su12345su/article/details/50581991

版权

sql server 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

--分组列出性别  计算男女各人数 和所占比例
select tsex ,count(*) from person_info where ttype='在职人员' group by tsex
--总人数
select count(*) from person_info
--占比
select cast( convert (decimal(18,2),100*cast(count(*) as float)/cast((select count(*) from person_info)  as float) ) as varchar)+'%' from person_info
--每个占比
select tsex 性别 ,count(*) 人数,
cast( convert (decimal(18,2),100*cast(count(*) as float)/cast((select count(*) from person_info)  as float) ) as varchar)+'%'
from person_info where ttype='在职人员' group by tsex
--存储过程
alter proc proc_person_sex_select
as
begin
	declare @sumPerson float
	set @sumPerson=cast((select count(*) from person_info)  as float)
	select tsex 性别 ,count(*) 人数,
    cast( convert (decimal(18,2),100*cast(count(*) as float)/@sumPerson ) as varchar)+'%' 各占比例
     from person_info where ttype='在职人员' group by tsex
end
--执行
exec proc_person_sex_select