By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| RouteName | LineName | LineTime |
|---|---|---|
| A | A01 | 2021-09-09 07:00:00.000 |
| A | A02 | 2021-09-09 08:00:00.000 |
| A | A03 | 2021-09-09 09:00:00.000 |
| A | A04 | 2021-09-09 10:00:00.000 |
| A | A05 | 2021-09-09 11:00:00.000 |
| B | B01 | 2021-09-09 12:00:00.000 |
| B | B02 | 2021-09-09 13:00:00.000 |
| B | B03 | 2021-09-09 14:00:00.000 |
| B | B04 | 2021-09-09 15:00:00.000 |
| B | B05 | 2021-09-09 16:00:00.000 |
| RouteName | LineName | LineTime | RouteTime |
|---|---|---|---|
| A | A05 | 2021-09-09 11:00:00.000 | 2021-09-09 05:10 |
| B | B05 | 2021-09-09 16:00:00.000 | 2021-09-09 05:10 |
| A | A01 | 2021-09-09 07:00:00.000 | 2021-09-09 07:10 |
| B | B05 | 2021-09-09 16:00:00.000 | 2021-09-09 07:10 |
| A | A05 | 2021-09-09 11:00:00.000 | 2021-09-09 16:10 |
| B | B05 | 2021-09-09 16:00:00.000 | 2021-09-09 16:10 |