Re: Selecting table row with latest date

On Thursday, August 19, 2021, Rich Shepard <rshepard(at)appl-ecosys(dot)com> wrote:

> 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

What’s your point?

> 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
> ^
>

Yeah, you wrote two from clauses…

David J.