| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Selecting table row with latest date |
| Date: | 2021-08-19 14:49:16 |
| Message-ID: | CAKFQuwbWpHGBrMvo4jPQKBxKQm9bSRNZTtr5-Sq8V-PHrymhrQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday, August 19, 2021, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:
> On Thu, 19 Aug 2021, Rich Shepard wrote:
>
> Please point me to the proper place in the docs where I can learn how to do
>> this.
>>
>
> If I use DISTINCT ON would this produce the most recent date for each
> person_nbr?
>
Yes, I mis-read your request and thought you wanted the most recent per
contact. Frankly, the single most recent is too simple that my mind didn’t
register that possibility.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rich Shepard | 2021-08-19 15:39:39 | Re: Selecting table row with latest date |
| Previous Message | Rich Shepard | 2021-08-19 14:47:40 | Re: Selecting table row with latest date |