By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
ID | ORIGIN | DESTINATION | ID | ORIGIN | DESTINATION |
---|---|---|---|---|---|
1 | A | B | 3 | B | A |
2 | C | D | 5 | D | C |
3 | B | A | 1 | A | B |
4 | C | A | null | null | null |
5 | D | C | 2 | C | D |
Route | Cnt |
---|---|
Route AB | 2 |
Route CA | 1 |
Route CD | 2 |