Hey Rich, On Tue, Feb 12, 2019 at 4:24 PM Rich Shepard <rshep...@appl-ecosys.com> wrote:
> The query is to return the latest next_contact date for each person. Using > the max() aggregate function and modeling the example of lo_temp on page 13 > of the rel. 10 manual I wrote this statement: > I use DISTINCT ON and ORDER BY to get the single latest value from a table with multiple date entries: https://stackoverflow.com/questions/9795660/postgresql-distinct-on-with-different-order-by HTH, -m