Search Postgresql Archives

Selecting table row with latest date

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thursday, August 19, 2021, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[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]

  Powered by Linux