Home > mailing lists

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

From	Ken Tanzer
Subject	Re: Subquery to select max(date) value
Date	March 29, 2019 02:09:21
Msg-id	CAD3a31WRASiBjSnHuz=CObtbkz7-M7yUC6yDsDieusFqVS_m_w@mail.gmail.com Whole thread Raw
In response to	Re: Subquery to select max(date) value ("David G. Johnston" <david.g.johnston@gmail.com>)
List	pgsql-general

Tree view

On Thu, Mar 28, 2019 at 4:07 PM David G. Johnston <david.g.johnston@gmail.com> wrote:

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.