Guest User

Untitled

a guest
Mar 18th, 2018
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.34 KB | None | 0 0
  1. WITH RECURSIVE path(company_name, job, name, step) AS (
  2. SELECT c.company_name, c.job, c.name, 1
  3. FROM Company c
  4. WHERE person = 'Bob Ross'
  5.  
  6. UNION ALL
  7.  
  8. SELECT p.company_name, p.job, p.name, c.step+1
  9. FROM path p JOIN Company c ON p.person = c.person
  10. WHERE c.person = 'Celine Dion'
  11. )
  12. SELECT * FROM path;
Add Comment
Please, Sign In to add comment