Re: Summing hierarchical data SQL

From: Mike C <michaeljc70_at_hotmail.com>
Date: 4 Oct 2006 12:53:29 -0700
Message-ID: <1159991609.526290.90790@b28g2000cwb.googlegroups.com>

Michel Cadot wrote:
> "Mike C" <michaeljc70_at_hotmail.com> a écrit dans le message de news: 1159989707.458848.89750_at_c28g2000cwb.googlegroups.com...
> I've already used the connect by to get the data in this format....
>
> -----------------------
>
> - Don't top post
> - So go on, you can easely get the sum over the hierarchy with a connect by.
>
> Regards
> Michel Cadot

This doesn't really need a CONNECT BY as it only needs to look at 1 level below. To get the sum for level 1, it only needs to look at level 2, etc. If I could "easily get the sum" I would have done it and wouldn't have posted to the group! Received on Wed Oct 04 2006 - 14:53:29 CDT