Postgres Pro
Downloads
Home   >   mailing lists

Re: Subquery to select max(date) value - Mailing list pgsql-general

From David G. Johnston
Subject Re: Subquery to select max(date) value
Date
Msg-id CAKFQuwaSCp-0EQAhFecEG2meTBA=sbKZ2_9qFxhbG4SPiroSrQ@mail.gmail.com
Whole thread Raw
In response to Re: Subquery to select max(date) value  (Ken Tanzer <ken.tanzer@gmail.com>)
Responses Re: Subquery to select max(date) value  (Ken Tanzer <ken.tanzer@gmail.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Subquery to select max(date) value
Next
From: Ken Tanzer
Date:
Subject: Re: Subquery to select max(date) value