add batch remove batch split batch show hidden batches hide batch
db<>fiddle
feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
deviceID AreaId DeviceStatus
1 1 Active 00:00 hrs to 03:00 hrs
1 2 Inactive 00:00 hrs to 01:00 hrs and Active 01:00 hrs to 03:00 hrs
1 3 Active 00:00 hrs to 01:00 hrs and Inactive 01:00 hrs to 04:00 hrs and Active 04:00 hrs to 06:00 hrs and Inactive 06:00 hrs to 08:00 hrs
1 4 Inactive 00:00 hrs to 01:00 hrs and Active 01:00 hrs to 02:00 hrs and Inactive 02:00 hrs to 03:00 hrs