By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Records: 9 Duplicates: 0 Warnings: 0
| UID | creation_date | row_num | DIFF_time | Cum_Diff | Category | grp |
|---|---|---|---|---|---|---|
| Cust 1 | 2023-06-13 15:12:00 | 1 | 0 | 0 | Unique | 0 |
| Cust 1 | 2023-06-13 18:43:05 | 2 | 12665 | 0 | Unique | 1 |
| Cust 1 | 2023-06-13 18:43:19 | 3 | 14 | 14 | Repeat | 1 |
| Cust 2 | 2023-06-08 22:25:00 | 1 | 0 | 0 | Unique | 0 |
| Cust 2 | 2023-06-10 14:32:12 | 2 | 144432 | 0 | Unique | 1 |
| Cust 3 | 2023-06-12 10:23:00 | 1 | 0 | 0 | Unique | 0 |
| Cust 4 | 2023-06-13 18:57:26 | 1 | 0 | 0 | Unique | 0 |
| Cust 4 | 2023-06-13 18:58:00 | 2 | 34 | 34 | Repeat | 0 |
| Cust 4 | 2023-06-13 18:58:43 | 3 | 43 | 77 | Repeat | 0 |