Hi Venu, all!
VenuGopal Papasani wrote:
Hi all,
I Have a table with followin structure where i have orgunit and parent
and value
orgunitparent value
12 10 x
15
Hi all,
I Have a table with followin structure where i have orgunit and parent
and value
orgunitparent value
12 10 x
1512 y
16
orgunit parent value
12 10 x
15 12 y
16 12 z
17 12 p
Now here 15,16, and 17 are the children of 12 and 12
is the
child of 10.Now i need a query which gives the sum of all the
children of
12 and nturn 12 itself . i.e I need the sum(values(15+16+17+12)).Is
there a
query which gives the