(Akshay Srinivasan2) A simple table in a relational database is the employees table. This has an employee ID and a reports to ID which is an employee ID. The normal way to fill your tree with this hierarchical information is to query for the root nodes i.e. nodes with no parents in this case null in
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help