By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Id | RouteId | Milepoint | RoadCondition | ContinuousId |
|---|---|---|---|---|
| 1 | A | 0 | X | 1 |
| 2 | A | 1 | X | 1 |
| 3 | A | 4 | Y | 2 |
| 4 | B | 0 | Y | 3 |
| 5 | B | 2 | null | 4 |
| 6 | B | 5 | null | 5 |
| 7 | B | 6 | Z | 6 |
| 8 | B | 18 | Z | 6 |
| 9 | C | 0 | X | 7 |
| Id | RouteId | Milepoint | RoadCondition | ContinuousId |
|---|---|---|---|---|
| 1 | A | 0 | X | 1 |
| 2 | A | 1 | X | 1 |
| 3 | A | 4 | Y | 2 |
| 4 | B | 0 | Y | 3 |
| 5 | B | 2 | null | 4 |
| 6 | B | 5 | null | 5 |
| 7 | B | 6 | Z | 6 |
| 8 | B | 18 | Z | 6 |
| 9 | C | 0 | X | 7 |