By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| Code | Value | GrpCode | GrpDft | rn |
|---|---|---|---|---|
| A | 1 | A1 | N | 1 |
| D | 2 | A2 | Y | 1 |
| E | null | A3 | Y | 1 |
6 rows affected
| Code | Value | GrpCode | GrpDft | rn |
|---|---|---|---|---|
| A | 1 | A1 | N | 1 |
| D | 2 | A2 | Y | 1 |
| E | null | A3 | Y | 1 |