SQL: Recursive Path

Posted by Chris on Stack Overflow See other posts from Stack Overflow or by Chris
Published on 2010-04-29T14:10:33Z Indexed on 2010/04/29 14:17 UTC
Read the original article Hit count: 264

Filed under:
|

Is it possible to create a "tree resolver" in SQL?

I have a table:

ID Name Parent
1  a
2  b    1
3  c    1
4  d    3

Now I want a SQL query that returns:

ID   PATH
1    /a
2    /a/b
3    /a/c
4    /a/c/d

Is this possible with SQL? It would make many things easier for me. Any help would really be appreciated!

© Stack Overflow or respective owner

Related posts about sql

Related posts about tree