By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
| ID | fieldA | fieldB | fieldC | RN |
|---|---|---|---|---|
| 3 | A | X | 3 | 1 |
| 4 | A | Y | 4 | 1 |
| 6 | B | Y | 2 | 1 |
| 9 | B | Z | 5 | 1 |
9 rows affected
| ID | fieldA | fieldB | fieldC | RN |
|---|---|---|---|---|
| 3 | A | X | 3 | 1 |
| 4 | A | Y | 4 | 1 |
| 6 | B | Y | 2 | 1 |
| 9 | B | Z | 5 | 1 |