By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| PROJ_ID | ROAD_ID | YEAR_ | STATUS | FROM_MEASURE | TO_MEASURE |
|---|---|---|---|---|---|
| 100 | 1 | 2022 | APPROVED | null | 100.1 |
| 101 | 1 | 2022 | APPROVED | 0 | 100.1 |
| 102 | 1 | 2022 | APPROVED | 0 | 200.6 |
| 103 | 1 | 2022 | APPROVED | 0 | 199.3 |
| 104 | 1 | 2022 | APPROVED | 0 | 201 |