I'm trying to sum a quantity in a query like this :
select sum(qty) as "myqty"...
But when trying to filter by this qty i have the following error :
Invalid use of group function
which is exact because we can't have a "where sum(qty) = xxx" in the query.
Is there a mean to use a group by...having sum(qty) = xxx instead ? or any other way to make the filter working
Hi,
I'm trying to sum a quantity in a query like this : select sum(qty) as "myqty"...
But when trying to filter by this qty i have the following error : Invalid use of group function which is exact because we can't have a "where sum(qty) = xxx" in the query. Is there a mean to use a group by...having sum(qty) = xxx instead ? or any other way to make the filter working
Best regards