Re: Selecting table row with latest date

On Thu, 19 Aug 2021, Adrian Klaver wrote:

> So take David Johnston's query:
> Select distinct on (person_nbr) ….. order by person_nbr, contact_date desc;

Adrian,

contact_date 
--------------
  2021-08-17
  2019-05-14
  2019-05-15
  2021-08-17
  2018-04-05
  2021-08-17
  2018-04-05
  2021-07-23
  2019-04-01
  2019-05-10
  2019-03-15
  2021-08-17
  2019-04-16
  2019-05-15
  2021-08-17
  2019-05-29
  2021-08-17
  2019-05-29
  2021-07-23
  2021-08-12
...

> and add the next_contact filter:
>
> Select distinct on (person_nbr) * from contacts where next_contact <= 
> current_date order by person_nbr, contact_date desc;

Select distinct on (p.person_nbr) * from c.contacts
from people as p, contacts as c
where cnext_contact <= current_date and
p.person_nbr = c.person_nbr
order by p.person_nbr, c.contact_date desc;

$ psql -d bustrac -f test_query.sql
psql:test_query.sql:5: ERROR:  syntax error at or near "from"
LINE 2: from people as p, contacts as c
         ^

I still am missing quite a bit.

Rich