By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| Id | User | File | StartId | NewSessionFlag | (No column name) |
|---|---|---|---|---|---|
| 1 | A | X | 1 | 1 | 1 |
| 2 | A | X | 1 | null | 1 |
| 3 | B | Y | 3 | 3 | 3 |
| 4 | A | X | 1 | null | 1 |
| 5 | B | Y | 3 | null | 3 |
| 6 | A | Y | 6 | 6 | 6 |
| 7 | A | X | 7 | 7 | 7 |
Warning: Null value is eliminated by an aggregate or other SET operation.