Postgres Pro
Downloads
Home   >   mailing lists

Re: Query help - Mailing list pgsql-general

From David G. Johnston
Subject Re: Query help
Date
Msg-id CAKFQuwbGsXNkoO=_KFzFm8CcKCc6BMrwmo5RdsEx_JceWt0+Bg@mail.gmail.com
Whole thread Raw
In response to Query help  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Tuesday, January 1, 2019, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, January 1, 2019, Chuck Martin <clmartin@theombudsman.com> wrote:
results wanted-all transactions where account total >= 50

id.         amount.      accountid.    name
1.          50.              1                   bill
3.          75.              1                   bill
4           25.              1                   bill
5           50               3                   sarah

This result does not require group by, just the where clause you’ve noted above.


Never mind...missed how the 25 got included

David J.
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Query help
Next
From: Adrian Klaver
Date:
Subject: Re: Query help