＋设为首页 ＋添加到收藏夹
select dept,count(dept)
from employee
group by dept
以上语句实现统计各部门人数，但是如果要求统计各部门人数占总人数百分比时如何实现？
你要先算出总人数才能进行计算，如
declare @cnt money
select @cnt=count(dept) from employee
select dept,count(dept) as bmrs,round(count(dept)/@cnt,2) as bfb
from employee
group by dept
select dept , round(t1.dcc/t2.tcc,2) as bfb
from ( select dept,count(dept) dcc
from employee
group by dept
) t1,
(select count(dept) tcc from employee ) t2
没有实验， 你看行不行？？
