Hello,
My problem is that I want to select the row with max(date) but also
limited with where clauses.
Select
test.name
from
test
where
test.name = foo.name
having max(test.date)
This is a subquery and is part bigger query. How I can select the row
with the max query.
ERROR: argument of HAVING must be type boolean, not type date
This is the error I receive.
As far as I know I can't use agregate functions in where clause.
Thank you in advance.
Kaloyan Iliev