Re: A GROUP BY question

> On 13 Aug 2019, at 15:19, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
> On Tuesday, August 13, 2019, Alban Hertroys <haramrae(at)gmail(dot)com> wrote:
>
> > On 13 Aug 2019, at 13:10, stan <stanb(at)panix(dot)com> wrote:
> >
> > select
> > project.proj_no ,
>
> Removed columns that get in the way of your desired result. You can’t have both details and the sum over them in a meaningful way.
>
> Sure you can, at least generally, with Window Functions/Expressions (i.e., OVER)

That’s why I added “in a meaningful way” ;)

Repeating the same SUM-result on every line in a group is not what I’d call a meaningful result; the SUM has no bearing on the detailed line and leads to the kind of mistakes I already mentioned.
(For the record; I do this kind of grouping in a hierarchical database regularly, but there the grouped SUM is at a different level in the hierarchy and I consider it thus sufficiently separated from the detail rows.)

Besides, I figured the OP was already struggling with the query syntax, adding window functions into the mix didn’t seem a good idea in the context. Possible?, sure, desirable?, I would say not.

Alban Hertroys
--
There is always an exception to always.