By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
| ORDERNUMBER | ORDERDATE | IS_RESTORE | ORDERTYPE | RN | RNK |
|---|---|---|---|---|---|
| 90/4/2 | 13-MAR-15 | 1 | 5 | 2 | 1 |
2 rows affected
| ORDERNUMBER | ORDERDATE | IS_RESTORE | ORDERTYPE | RN | RNK |
|---|---|---|---|---|---|
| 90/4/2 | 13-MAR-15 | 1 | 5 | 2 | 1 |