Sum the time value against results for same object ids
I have scenario where I need to sum the time values against results for same object ids.
object_id result_id value
301 111 0.1
301 112 0.1
301 113 0.2
302 114 0.3
304 115 0.1
305 116 0.2
306 117 0.3
i need a logic where all values aganist result_ids within same object_id will be summed and put under one object id.
Like, for object_id 301, the value would be 0.1+0.1+0.2 = 0.4
Please advise!
Regards,
Saurav