By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| Id | Pin | Time | DeviceMode | (No column name) |
|---|---|---|---|---|
| 23086 | 7756 | 2023-01-06 07:27:00.000 | IN | 2023-01-06 10:20:00.000 |
| 23237 | 7756 | 2023-01-06 09:10:00.000 | OUT | null |
| 23241 | 7756 | 2023-01-06 09:11:00.000 | OUT | null |
| 23246 | 7756 | 2023-01-06 09:12:00.000 | OUT | null |
| 23248 | 7756 | 2023-01-06 09:13:00.000 | OUT | null |
| 23301 | 7756 | 2023-01-06 10:20:00.000 | OUT | null |