By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
3 rows affected
| CustNum | LicAddr1 | Lic1 | ExpiryDate1 | LicAddr2 | Lic2 | ExpiryDate2 | LicAddr3 | Lic3 | ExpiryDate3 |
|---|---|---|---|---|---|---|---|---|---|
| 155 | 123 | Y32CA | 2018-12-31 | 998 | Y32CB | 2020-12-31 | 568 | Y32CC | 2022-12-31 |
Warning: Null value is eliminated by an aggregate or other SET operation.