Search Postgresql Archives
Re: Selecting table row with latest date
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Selecting table row with latest date
From
: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date
: Thu, 19 Aug 2021 07:40:19 -0700
Cc
: "pgsql-general@xxxxxxxxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <
alpine.LNX.2.20.2108190730510.15165@salmo.appl-ecosys.com
>
References
: <
alpine.LNX.2.20.2108190730510.15165@salmo.appl-ecosys.com
>
On Thursday, August 19, 2021, Rich Shepard <
rshepard@xxxxxxxxxxxxxxx
> wrote:
I have a table of contacts (PK is the person_nbr and contact_date)
Select distinct on (person_nbr) ….. order by person_nbr, contact_date desc;
David J.
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: Selecting table row with latest date
From:
Rich Shepard
References
:
Selecting table row with latest date
From:
Rich Shepard
Prev by Date:
Selecting table row with latest date
Next by Date:
Re: Selecting table row with latest date
Previous by thread:
Selecting table row with latest date
Next by thread:
Re: Selecting table row with latest date
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]
