34,576
社区成员
发帖
与我相关
我的任务
分享
select
a.项目号 as 项目编号,
sum(case when b.工作场地=1 then 1 else 0 end) as 本地人数,
sum(case when b.工作场地=2 then 1 else 0 end) as 现场人数,
count(b.工作场地) as 总计人数
from
表1 a inner join 表2 b on a.项目管理职位ID =b.职位ID
group by
a.项目号
select
a.项目号 as 项目编号,
sum(case when b.工作场地=1 then 1 else 0 end) as 本地人数,
sum(case when b.工作场地=2 then 1 else 0 end) as 现场人数,
count(b.工作场地) as 总计人数,
(select count(*) from 表1) as '合计'
from
表1 a inner join 表2 b on a.项目管理职位ID =b.职位ID
group by
a.项目号