table1的表如下:
time score user
08:00:00 50 zhao
08:00:00 60 zhao
08:00:00 50 null
08:00:50 20 qian
08:01:00 50 sun
08:01:00 50 sun
08:02:00 10 li
08:02:01 80 li
08:02:01 50 li
把时间相同的,连续的user的score相加,得出以下结果:
time total-score user
08:00:00 110 zhao
08:00:50 20 qian
08:01:00 100 sun
08:02:00 10 li
08:02:01 130 li
------解决思路----------------------
Select User,Time,Sum(Score) As TotalScore
From Table1
Group By User,Time