Re: Subquery to select max(date) value

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Feb 12, 2019 at 3:24 PM Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote:
> psql:next_contact_date.sql:7: ERROR:  syntax error at or near "select"
> LINE 4:       A.next_contact = select (max(A.next_contact) from A)
>                                 ^
> and I fail to see what I've done incorrectly.

You put the open parenthesis after the word select instead of before.

A.next_contact = (SELECT max(A.next_contact) FROM A)

David J.