On Thu, 19 Aug 2021, David G. Johnston wrote:
> Select distinct on (person_nbr) ….. order by person_nbr, contact_date
> desc;
David,
Please clarify: would this produce the most recent contact_date for each
person_nbr? The manual reads that two rows (e.g., for the same person_nbr)
are considered distinct if they differ in any one column (e.g.,
contact_dates).
Still confused.
Rich