By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| worker_name | log_time | in_out |
|---|---|---|
| User 1 | 2018-05-14 07:24:40.000 | IN |
| User 2 | 2018-05-14 11:55:29.000 | IN |
| User 3 | 2018-05-14 14:03:26.000 | IN |
| User 1 | 2018-05-14 14:05:08.000 | Out |
| User 3 | 2018-05-14 20:08:30.000 | Out |
| User 2 | 2018-05-14 20:08:36.000 | Out |
| User 4 | 2018-05-14 20:09:14.000 | Out |