62,050
社区成员
发帖
与我相关
我的任务
分享
select work_year as 工作年限 ,count(*) as 数量,
convert(decimal(18,2),count(*)*100./(select count(*) from info_person)) as 所占比例
from info_person
group by work_year
SELECT distinct work_year
,COUNT(*) OVER (PARTITION BY 0) AS all_count
,COUNT(*) OVER (PARTITION BY work_year) AS part_count
,ROUND(CONVERT(FLOAT,COUNT(*) OVER (PARTITION BY work_year))*100/CONVERT(FLOAT,COUNT(*) OVER (PARTITION BY 0)),2) AS part_point
FROM info_person