>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.

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
  