问题如下:
| id | time | dtime2 |
| 10000012 | 2017/2/5 | 0 |
| 10000012 | 2018/6/26 | 506 |
| 10000650 | 2018/1/15 | -162 |
| 10000652 | 2016/3/23 | -663 |
| 1000091 | 2016/9/7 | 168 |
| 1000091 | 2017/8/30 | 357 |
| 10001987 | 2016/3/23 | -525 |
| 10002687 | 2015/12/26 | -88 |
| 10003140 | 2019/8/13 | 1326 |
| 10003188 | 2015/10/13 | -1400 |
| 10003519 | 2017/7/14 | 640 |
| 10003848 | 2016/6/17 | -392 |
| 10003851 | 2017/1/28 | 225 |
| 10003851 | 2017/1/28 | 0 |
| 10003851 | 2017/3/14 | 45 |
表已经按照id,time排好序了,想把每个id下最早的一条记录下的dtime2的值替换为0;
请问怎么能实现呢?谢谢!