Re: "ORA-00935: group function is nested too deeply" in oracle8.1.7

Try "order by Flow" instead of "order by sum(Flow)".

mmrgood_at_sina.com (Mary.M) wrote in message news:<59b71f2d.0208080156.1c7ef5b_at_posting.google.com>...
> Hi, all gurus,
>
> I encounter a very weird thing, who can help me?
>
> I have a SQL statement:
> "select IPAddr,sum(Flow)/1048576 Flow,avg(FlowRate)/1024 FlowRate from
> (select SrcAddr as IPAddr,sum(Octets) Flow,sum(Octets)/(count(*) *
> 86400) FlowRate from TrafficComingDailyData where DestAddr =
> '192.168.0.130' and StartTime >= to_date('2002-8-1','yyyy-mm-dd
> hh24:mi:ss') and StartTime < to_date('2002-8-8 17:8','yyyy-mm-dd
> hh24:mi:ss') group by SrcAddr
> union all
> select DestAddr as IPAddr,sum(Octets) Flow,sum(Octets)/(count(*) *
> 86400) FlowRate from TrafficGoingDailyData where SrcAddr =
> '192.168.0.130' and
> StartTime >= to_date('2002-8-1','yyyy-mm-dd hh24:mi:ss') and
> StartTime < to_date('2002-8-8 17:8','yyyy-mm-dd hh24:mi:ss') group by
> DestAddr)
> group by IPAddr order by sum(Flow) desc"
>
> When I run it under oracle8.1.5, there is no prblem.
> But when I run it under oracle8.1.7, error happends:
> " group by IPAddr order by sum(Flow) desc
> *
> ERROR at line 10:
> ORA-00935: group function is nested too deeply".
>
> What is the reason?
> Thanks in advance!
> By Mary.M.
Received on Thu Aug 08 2002 - 22:51:02 CEST