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.