By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| StartNode | EndNode | StartNodeIsVisible | EndNodeIsVisible | Depth |
|---|---|---|---|---|
| A | B | True | True | 1 |
| D | E | True | True | 1 |
| B | D | True | True | 2 |
4 rows affected
| StartNode | EndNode | StartNodeIsVisible | EndNodeIsVisible | Depth |
|---|---|---|---|---|
| A | B | True | True | 1 |
| D | E | True | True | 1 |
| B | D | True | True | 2 |