1.原始数据
date Employee Name TimeIn SUM
2009-5-1 AA 12:10:00 10
2009-5-1 AA 13:00:00 20
2008-8-2 BB 16:00:00 10
2008-8-2 BB 15:00:00 3
2009-6-1 DD 13:00:00 9
2009-6-1 DD 15:20:00 12
2009-5-6 CC 10:00:00 14
------------------------------------------
2.经过下面sql语句后结果
select Date, [Employee Name] from EmployeeData where date>'2009-05-09' GROUP BY Date,[Employee Name] having count(TimeIn)=2 order by Date,[Employee Name]
date Employee Name
2009-5-1 AA
2008-8-2 BB
2009-6-1 DD
-------------------------------------------
3.现在我想更新SUN的数值,所有加1,条件是步骤2所得结果,依次date+ Employee Name .
update table set sum where date=2009-5-1 and [Employee Name]=AA
红色区域动态的
date Employee Name TimeIn SUM
2009-5-1 AA 12:10:00 10
2009-5-1 AA 13:00:00 20
2008-8-2 BB 16:00:00 10
2008-8-2 BB 15:00:00 3
2009-6-1 DD 13:00:00 9
2009-6-1 DD 15:20:00 12
2009-5-6 CC 10:00:00 14
------------------------------------------
2.经过下面sql语句后结果
select Date, [Employee Name] from EmployeeData where date>'2009-05-09' GROUP BY Date,[Employee Name] having count(TimeIn)=2 order by Date,[Employee Name]
date Employee Name
2009-5-1 AA
2008-8-2 BB
2009-6-1 DD
-------------------------------------------
3.现在我想更新SUN的数值,所有加1,条件是步骤2所得结果,依次date+ Employee Name .
update table set sum where date=2009-5-1 and [Employee Name]=AA
红色区域动态的
select Date, [Employee Name] from EmployeeData where date>'2009-05-09' GROUP BY Date,[Employee Name] having count(TimeIn)=2 )
update cte set sum=sum+1 where date=2009-5-1 and [Employee Name]=AA
from ta
group by 时间,姓名
having count(1) = 2