Horton

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:28:13Z
Lists: pgsql-general 
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.

David J.