saikrishna80
Programmer
Hi all,
I have a table having columns like
parent child
1 2
1 3
1 4
2 5
2 6
4 7
5 8
7 9
Now input is parent. output must be number of levels from that parent to end of the hierarchy.
for eg : input = 1 output = 3 levels
input = 5 output = 1 level
This is for Informix.
Regards
Sai Krishna
I have a table having columns like
parent child
1 2
1 3
1 4
2 5
2 6
4 7
5 8
7 9
Now input is parent. output must be number of levels from that parent to end of the hierarchy.
for eg : input = 1 output = 3 levels
input = 5 output = 1 level
This is for Informix.
Regards
Sai Krishna