By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| CASE | SEQUENCE | VALUE1 | VALUE2 | RN |
|---|---|---|---|---|
| AA1001-02 | 699 | 72 | 182 | 1 |
| AB1002-02 | 707 | 51 | 38 | 1 |
| AA1003 | 683 | 113 | 416 | 1 |
11 rows affected
| CASE | SEQUENCE | VALUE1 | VALUE2 | RN |
|---|---|---|---|---|
| AA1001-02 | 699 | 72 | 182 | 1 |
| AB1002-02 | 707 | 51 | 38 | 1 |
| AA1003 | 683 | 113 | 416 | 1 |