Re: Subquery to select max(date) value

Поиск

Список

Период

Сортировка

От	Ken Tanzer
Тема	Re: Subquery to select max(date) value
Дата	29 марта 2019 г. 02:09:21
Msg-id	CAD3a31WRASiBjSnHuz=CObtbkz7-M7yUC6yDsDieusFqVS_m_w@mail.gmail.com обсуждение исходный текст
Ответ на	Re: Subquery to select max(date) value ("David G. Johnston" <david.g.johnston@gmail.com>)
Список	pgsql-general

Дерево обсуждения

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.