By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ID | DateTime | Value |
|---|---|---|
| ID1 | 2022-05-03 08:50:00.0370000 | 100 |
| ID1 | 2022-05-03 08:50:00.1370000 | 105 |
| ID1 | 2022-05-03 08:55:05.0371200 | 100 |
| ID1 | 2022-05-03 08:55:05.3210000 | 115 |
| ID1 | 2022-05-03 08:55:05.5320000 | 130 |
| ID1 | 2022-05-03 08:56:06.4220000 | 110 |
| ID1 | 2022-05-03 08:58:08.0312300 | 105 |
| ID1 | 2022-05-03 09:00:00.0424400 | 100 |
| ID | Value | DateTime | rn |
|---|---|---|---|
| ID1 | 100 | 2022-05-03 08:50:00.0370000 | 1 |
| ID1 | 100 | 2022-05-03 08:55:05.0371200 | 1 |
| ID1 | 100 | 2022-05-03 09:00:00.0424400 | 1 |