>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 sum of all these.It will be very helpful if i am able

>to get it in a single query.

SELECT parent, parent + SUM(orgunit)

FROM table

GROUP BY parent;

PB

-----

VenuGopal Papasani wrote:

Hi all,

I Have a table with followin structure where i have orgunit and parent

and value

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 sum of all these.It will be very helpful if i am able

to get it in a single query.

Thanks and regards,

venu.

No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.8/380 - Release Date: 6/30/2006