[SQL] Problems with HAVING

[Kaloyan Iliev Iliev]

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