DB2, Microsoft SQL Server, Oracle and PostgreSQL all support recursive queries using CTEs ... The MGR_ID for the top-most node is set to some value indicating that there is no parent for this row, in ...

Here's the deal: I have a database with table called Categories. Categories has a parent-child relationship in them. Here's what the table looks like (exluding stuff not related to the problem ...