| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Chuck Martin <clmartin(at)theombudsman(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Query help |
| Date: | 2019-01-01 19:29:13 |
| Message-ID: | CAKFQuwbGsXNkoO=_KFzFm8CcKCc6BMrwmo5RdsEx_JceWt0+Bg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tuesday, January 1, 2019, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:
> On Tuesday, January 1, 2019, Chuck Martin <clmartin(at)theombudsman(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2019-01-01 19:40:22 | Re: Query help |
| Previous Message | David G. Johnston | 2019-01-01 19:28:13 | Query help |