By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| MyPID | MyIDNum | MyAgency | MyCCode | MyDate |
|---|---|---|---|---|
| 12345A | F12345678 | RYPX | 23 | 24/10/2018 20:39:00 |
| 12345A | F23456789 | RYPX | 23 | 24/10/2018 18:39:00 |
| 23456A | G12345678 | RYPX | 23 | 10/10/2018 07:38:00 |
| 23456A | H12345678 | RYPX | 30 | 10/10/2018 07:38:00 |
| 34567C | E12345678 | RYPX | 62 | 21/03/2017 12:43:00 |
| mypid | mydate | (No column name) |
|---|---|---|
| 12345A | 24/10/2018 18:39:00 | 1 |
| 12345A | 24/10/2018 20:39:00 | 2 |
| 23456A | 10/10/2018 07:38:00 | 3 |
| 23456A | 10/10/2018 07:38:00 | 4 |
| 34567C | 21/03/2017 12:43:00 | 5 |