By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 8 Duplicates: 0 Warnings: 0
| id | date | time | title | rnk |
|---|---|---|---|---|
| 1 | 2023-03-03 | 2023-03-03 10:00:00 | A | 1 |
| 1 | 2023-03-03 | 2023-03-03 10:30:00 | B | 2 |
| 1 | 2023-03-03 | 2023-03-03 10:50:00 | C | 3 |
| 2 | 2023-03-03 | 2023-03-03 12:00:00 | A | 1 |
| 2 | 2023-03-03 | 2023-03-03 12:20:00 | B | 2 |