Select Left(部门编号,3),sum(人数) from Deptment Group by Left(部门编号,3)
Union
Select 部门编号,sum(人数) from Deptment where len(部门编号) = 5 Group by 部门编号
Union
Select 部门编号,sum(人数) from Deptment where len(部门编号) = 5 Group by 部门编号
,(select sum(人数) from Deptment where 部门编号 in (select 部门编号 from Deptment where 部门编号 like a.部门编号+'%' )) as 人数
from Deptment a
group by 部门编号,部门名称
order by 部门编号,部门名称
,(select sum(人数)
from Deptment
where 部门编号 in (select 部门编号
from Deptment
where 部门编号 like a.部门编号+'%' )) as 人数
from Deptment a
group by 部门编号
order by 部门编号