Re: Selecting table row with latest date [RESOLVED]

Поиск
Список
Период
Сортировка
От Rich Shepard
Тема Re: Selecting table row with latest date [RESOLVED]
Дата
Msg-id alpine.LNX.2.20.2108191451030.15165@salmo.appl-ecosys.com
обсуждение исходный текст
Ответ на Re: Selecting table row with latest date [RESOLVED]  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Selecting table row with latest date [RESOLVED]  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-general
Дерево обсуждения 
On Thu, 19 Aug 2021, David G. Johnston wrote:

> I thought you said (p.person_nbr, c.contact_date) is already unique?

David,

Yes, that's the PK for the contacts table. I'm still unsure what needs to be
explicitly included in a query. Quite often I leave out a column and
postgres tells me it needs to be included in order by or group by.

Rich

В списке pgsql-general по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Selecting table row with latest date [RESOLVED]
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Selecting table row with latest date [RESOLVED]