Re: A GROUP BY question - Mailing list pgsql-general

From David G. Johnston
Subject Re: A GROUP BY question
Date
Msg-id CAKFQuwZL9v1X8obfq09yBjs2oVthr0LfZ4yi-hiUCFTNjKeKwQ@mail.gmail.com
Whole thread Raw
In response to Re: A GROUP BY question  (Alban Hertroys <haramrae@gmail.com>)
Responses Re: A GROUP BY question
List pgsql-general
On Tuesday, August 13, 2019, Alban Hertroys <haramrae@gmail.com> wrote:

> On 13 Aug 2019, at 13:10, stan <stanb@panix.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)

David J.

pgsql-general by date:

Previous
From: Jan Kohnert
Date:
Subject: Re: A GROUP BY question
Next
From: Souvik Bhattacherjee
Date:
Subject: Re: Bulk Inserts