Re: Real world issue: How to "split" queries in presence of record replication and replication sensitive aggregate functions ?

Bob Badour ha scritto:

> Marshall wrote:
>
> > pamelafluente_at_libero.it wrote:
> >
> >>This involves a group of record and requires a GROUP BY clause.
> >
> > It's the other way around, actually: a GROUP BY requires an
> > aggregate function, but an aggregate function does not require
> > a GROUP BY.
>
> I doubt very many if any dbmses require an aggregate function for a
> group by. Without any aggregates, group by is synonymous with project.
>
Let's drop this detail that is unimportant for the main problem..

> If that choice indicates where the ignorant learned about database
> theory, that explains a lot.
>

It doesn't. I never learned it.

-P Received on Sat Sep 16 2006 - 12:24:41 CEST