Count Left Nodes
-
Hello Friends, I've a table as given below ID LChild RChild 1 2 3 2 4 6 3 5 7 4 8 9 5 10 11 6 12 13 7 0 14 Now i've to find out the LChild of 1, 1 has 2 in it's left and 2 has 4,6 as it's child and 4 and 6 has also two-two child each......At final 1 has 7 child on it's left and on it's Right it's 6 And also i've find out for each ID i.e 1,2,3,4,5,6,7
-
Hello Friends, I've a table as given below ID LChild RChild 1 2 3 2 4 6 3 5 7 4 8 9 5 10 11 6 12 13 7 0 14 Now i've to find out the LChild of 1, 1 has 2 in it's left and 2 has 4,6 as it's child and 4 and 6 has also two-two child each......At final 1 has 7 child on it's left and on it's Right it's 6 And also i've find out for each ID i.e 1,2,3,4,5,6,7
Yes I have same table and want sql query for counting left and right node