Saturday, 15 May 2010

sql server - How to create hierarchical table in SQL? -


If three managers and their employees are shown in the picture, how to design hierarchically in SQL.

Enter image details here

< Div class = "post-text" itemprop = "text">

I will only add a manager ID field which is not necessary.

If the field is not set to the person then one of the highest managers is that he works as an employee for a specific ID person.


No comments:

Post a Comment