Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH RECURSIVE path(company_name, job, name, step) AS (
- SELECT c.company_name, c.job, c.name, 1
- FROM Company c
- WHERE person = 'Bob Ross'
- UNION ALL
- SELECT p.company_name, p.job, p.name, c.step+1
- FROM path p JOIN Company c ON p.person = c.person
- WHERE c.person = 'Celine Dion'
- )
- SELECT * FROM path;
Add Comment
Please, Sign In to add comment