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
