Horton

Re: Query help

David G. Johnston <david.g.johnston@gmail.com>

View thread View on postgr.es
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Chuck Martin <clmartin@theombudsman.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2019-01-01T19:29:13Z
Lists: pgsql-general 
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.