Loading

inheritence property, adding members in tree structure

Joseph Eldho

8y782

to find the count of emps added by an emp(emp and emps column name)

employee 1 add 2 members(2,3) and employee 2 add 6 members ,here 2 adds (4,5) and 3 adds(6,7,8,9) and so on

how to write the query

emp emps

1 2

3

--------------------------------

2 4

5

6

7

8

9

---------------------------------

3 10

11

---------------------------------

4 12

13

etc,etc..............................

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manish Kumar8y ago
can you show some sample data in table format and required output.
May be you need to implement recursive cte.
0
Ramesh Palanivel8y ago
Hi Joeshph,

For your scenario, Please refer sql server "group by" and "Pivot". It will help you.
0