By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| Name | time | value |
|---|---|---|
| A | 2020-03-31 17:00:00.000 | 44 |
| A | 2020-03-31 18:00:00.000 | 56 |
| A | 2020-03-31 19:00:00.000 | 3 |
| B | 2020-03-31 14:00:00.000 | 14 |
| C | 2020-03-31 11:00:00.000 | 29 |
| C | 2020-03-31 15:00:00.000 | 26 |