Re: Subquery to select max(date) value

On Thu, Mar 28, 2019 at 4:05 PM Ken Tanzer <ken.tanzer@gmail.com> wrote:

 (And I don't think the one inside the lateral join is doing you any good).  Try:

...

              a.next_contact is not null
             limit 1) sq

            order by sq.next_contact DESC;

The fact that the subquery has a LIMT 1 clause leads me to assume the ORDER BY there is quite necessary.

David J.