By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 14 Duplicates: 0 Warnings: 0
| Card_ID | Date_Entry | Status_Entry |
|---|---|---|
| 5001201 | 2024-01-01 07:50:05 | IN |
| 5001201 | 2024-01-01 17:00:07 | OUT |
| 5001202 | 2024-01-01 07:56:00 | IN |
| 5001202 | 2024-01-01 17:01:15 | OUT |
| 5001203 | 2024-01-01 07:58:20 | IN |
| 5001204 | 2024-01-01 08:00:15 | IN |
| 5001204 | 2024-01-01 17:02:00 | OUT |
| 5001201 | 2024-01-02 07:55:05 | IN |
| 5001201 | 2024-01-02 17:02:07 | OUT |
| 5001202 | 2024-01-02 07:50:00 | IN |
| 5001202 | 2024-01-02 17:00:10 | OUT |
| 5001203 | 2024-01-02 07:59:20 | IN |
| 5001203 | 2024-01-02 08:03:15 | OUT |
| 5001204 | 2024-01-02 17:03:15 | OUT |
| Date_log | MaxDate |
|---|---|
| 2024-01-01 | 2024-01-02 |
| 2024-01-02 | 2024-01-02 |
| 2024-01-03 | 2024-01-02 |
| Card_ID | Date_log |
|---|---|
| 5001201 | 2024-01-01 |
| 5001201 | 2024-01-02 |
| 5001201 | 2024-01-03 |
| 5001202 | 2024-01-01 |
| 5001202 | 2024-01-02 |
| 5001202 | 2024-01-03 |
| 5001203 | 2024-01-01 |
| 5001203 | 2024-01-02 |
| 5001203 | 2024-01-03 |
| 5001204 | 2024-01-01 |
| 5001204 | 2024-01-02 |
| 5001204 | 2024-01-03 |
| Date_log | Card_ID | Clock_in | Clock_out |
|---|---|---|---|
| 2024-01-01 | 5001201 | 2024-01-01 07:50:05 | 2024-01-01 17:00:07 |
| 2024-01-01 | 5001202 | 2024-01-01 07:56:00 | 2024-01-01 17:01:15 |
| 2024-01-01 | 5001203 | 2024-01-01 07:58:20 | null |
| 2024-01-01 | 5001204 | 2024-01-01 08:00:15 | 2024-01-01 17:02:00 |
| 2024-01-02 | 5001201 | 2024-01-02 07:55:05 | 2024-01-02 17:02:07 |
| 2024-01-02 | 5001202 | 2024-01-02 07:50:00 | 2024-01-02 17:00:10 |
| 2024-01-02 | 5001203 | 2024-01-02 07:59:20 | 2024-01-02 08:03:15 |
| 2024-01-02 | 5001204 | null | 2024-01-02 17:03:15 |
| 2024-01-03 | 5001201 | null | null |
| 2024-01-03 | 5001202 | null | null |
| 2024-01-03 | 5001203 | null | null |
| 2024-01-03 | 5001204 | null | null |
| Date_log | Card_ID | Clock_in | Clock_out |
|---|---|---|---|
| 2024-01-01 | 5001201 | 2024-01-01 07:50:05 | 2024-01-01 17:00:07 |
| 2024-01-01 | 5001202 | 2024-01-01 07:56:00 | 2024-01-01 17:01:15 |
| 2024-01-01 | 5001203 | 2024-01-01 07:58:20 | null |
| 2024-01-01 | 5001204 | 2024-01-01 08:00:15 | 2024-01-01 17:02:00 |
| 2024-01-02 | 5001201 | 2024-01-02 07:55:05 | 2024-01-02 17:02:07 |
| 2024-01-02 | 5001202 | 2024-01-02 07:50:00 | 2024-01-02 17:00:10 |
| 2024-01-02 | 5001203 | 2024-01-02 07:59:20 | 2024-01-02 08:03:15 |
| 2024-01-02 | 5001204 | null | 2024-01-02 17:03:15 |
| 2024-01-03 | 5001201 | null | null |
| 2024-01-03 | 5001202 | null | null |
| 2024-01-03 | 5001203 | null | null |
| 2024-01-03 | 5001204 | null | null |