mcohen_at_attbi.com (Mike Cohen) wrote in message news:<9a742dd3.0302061111.27919255_at_posting.google.com>...
> Ron - yes I received Group By errors on the Sum and Count functions
> within the nested selects. The exact error messages are:
>
> "ORA-00979: not a GROUP BY expression"
> > > SELECT
> > > rcm.MSA,
> > > count(ttt.transaction_id),
> > > sum(ttt.SALE_PRICE),
> > > round(...) "AVERAGE" [snip]
> > > FROM ... [snip]
> > > WHERE ... [snip]
> > > GROUP BY
> > > rcm.MSA
round(...) is evaluated for each record. When grouping to MSA the
database system wonders how to aggregate the computed values. Do you
want to have the average over all the computed values? This would be
avg(round(...)).
Received on Fri Feb 07 2003 - 01:29:27 CST
