Advertisement
HwapX

Firebird recursive query

Jan 8th, 2014
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.16 KB | None | 0 0
  1. WITH recursive items(id, caption, parent) AS
  2. (SELECT * FROM test WHERE id = :p
  3. UNION ALL
  4. SELECT * FROM test t
  5. JOIN items i ON i.PARENT=t.id
  6. )
  7. SELECT * FROM items;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement