By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| A_NUMBER | items |
|---|---|
| 1 | i1,i2,i3,i4,i5,i6 |
| 2 | j1,j2,j3,j4,j5,i6,i7,i8 |
| 3 | k1,k2,k3 |
| A_NUMBER | items | Srllno1 | Srllno2 | Srllno3 | Srllno4 |
|---|---|---|---|---|---|
| 1 | i1,i2,i3,i4,i5,i6 | null | null | null | null |
| 2 | j1,j2,j3,j4,j5,i6,i7,i8 | null | null | null | null |
| 3 | k1,k2,k3 | k3 | k2 | k1 | null |
| A_NUMBER | items | Srllno1 | Srllno2 | Srllno3 | Srllno4 | SrllRest |
|---|---|---|---|---|---|---|
| 1 | i1,i2,i3,i4,i5,i6 | i1 | i2 | i3 | i4 | i5,i6 |
| 2 | j1,j2,j3,j4,j5,i6,i7,i8 | j1 | j2 | j3 | j4 | j5,i6,i7,i8 |
| 3 | k1,k2,k3 | k1 | k2 | k3 | null | null |
Warning: Null value is eliminated by an aggregate or other SET operation.