Issue around group by and having

SQL++
3

I found the solution to my problem. My bad

SELECT doc FROM zeusresource WHERE (
(tag.internal = ‘fordemo’ AND tag.external = ‘fordemo’) OR
(tag.internal = ‘trader’ AND tag.external = ‘trader’)
) AND
metadata.published <= 1496636763719
GROUP BY tag.external, tag.internal
letting doc = (MAX([metadata.published, {“id”: meta().id, “deleted”: metadata.deleted}]))[1]
HAVING doc.deleted = false

1 Like