List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:July 1 2006 3:50pm
Subject:Re: need one query
View as plain text  
 >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
>   

Attachment: [text/html]
No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.8/380 - Release Date: 6/30/2006
Thread
need one queryVenuGopal Papasani1 Jul
  • Re: need one queryPeter Brawley1 Jul
  • Re: need one queryJoerg Bruehe4 Jul