By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| alarmnumber | start_time | end_time |
|---|---|---|
| 1592 | 2020-01-02 01:52:02.000 | 2020-01-02 01:58:07.000 |
| 1592 | 2020-04-28 03:46:49.000 | 2020-04-28 06:19:10.000 |
| 1592 | 2020-06-04 00:25:22.000 | null |
| 1592 | 2020-08-27 01:57:03.000 | 2020-08-27 05:16:32.000 |
| 1592 | null | 2020-09-17 02:51:57.000 |
Warning: Null value is eliminated by an aggregate or other SET operation.