22,209
社区成员
发帖
与我相关
我的任务
分享
select FOperWork ,SUM([实际出勤工时]) as [实际出勤工时] from [表名] where FWorkStartDate between '查询起始时间' and '查询结束时间'
group by FOperWork
--drop table tb
create table tb (FWorkStartDate datetime, FOperWork varchar(10), FClassName varchar(10), 实际出勤工时 numeric(4,2), 折合工时 numeric(4,2))
insert into tb
select '2014/8/2','魏佳芬','注塑B班',11.50,6.97 union all
select '2014/8/2','肖利琼','注塑A班',11.50,6.09 union all
select '2014/8/2','苏顺贤','注塑A班',3.70,3.70 union all
select '2014/8/6','宋园园','注塑A班',8.00,8.02 union all
select '2014/8/6','王香','注塑A班',11.50,11.50 union all
select '2014/8/7','吴荣平','注塑A班',6.56,6.56 union all
select '2014/8/7','吴荣平','注塑A班',2.17,2.17 union all
select '2014/8/7','付艳','注塑B班',4.06,4.06 union all
select '2014/8/2','魏佳芬','注塑A班',11.50,11.54 union all
select '2014/8/4','肖利琼','注塑A班',2.28,2.28 union all
select '2014/8/7','魏佳芬','注塑B班',10.89,10.89 union all
select '2014/8/7','杨东梅','注塑B班',9.77,9.77 union all
select '2014/8/7','杨东梅','注塑B班',1.77,1.77 union all
select '2014/8/6','杨冬梅','注塑B班',6.46,6.46 union all
select '2014/8/7','吴荣平','注塑A班',2.17,2.17 union all
select '2014/8/9','付艳','注塑B班',11.50,11.50 union all
select '2014/8/10','吴荣平','注塑A班',8.07,8.07 union all
select '2014/8/10','吴荣平','注塑A班',2.03,2.03 union all
select '2014/8/8','苏顺贤','注塑A班',11.50,11.57 union all
select '2014/8/8','魏佳芬','注塑B班',11.50,11.56 union all
select '2014/8/9','苏顺贤','注塑B班',0.00,11.56 union all
select '2014/8/9','魏佳芬','注塑B班',11.50,11.57 union all
select '2014/8/14','陈允云','注塑B班',0.00,6.80 union all
select '2014/8/15','张小艳','注塑A班',5.87,5.87 union all
select '2014/8/15','邹书丽','注塑B班',5.71,5.71 union all
select '2014/8/16','张小艳','注塑A班',7.54,6.35 union all
select '2014/8/16','宋园园','注塑B班',7.58,6.39 union all
select '2014/8/18','宋园园','注塑B班',10.00,10.00
go
select FOperWork,SUM (实际出勤工时)as [实际],SUM (折合工时)as[折合] from tb
where FWorkStartDate between '2014-08-06 00:00:00.000' and '2014-08-07 00:00:00.000'
group by FOperWork
--FOperWork 实际 折合
--付艳 4.06 4.06
--宋园园 8.00 8.02
--王香 11.50 11.50
--魏佳芬 10.89 10.89
--吴荣平 10.90 10.90
--杨东梅 11.54 11.54
--杨冬梅 6.46 6.46