You can translate the question and the replies:

Denodo Data Catalog.v.7.0: Request for Having Clause

Denodo Data Catalog. Version 7.0 According to https://community.denodo.com/docs/html/browse/7.0/vdp/vql/queries_select_statement/having_clause/having_clause the Denodo 7 provides HAVING clause for filtering conditions on the results returned by a query using the GROUP BY clause. The 'Having' clause is the common and expected component of the Group By clause. However, this functionality is not available in the Data Catalog that diminishes the value of the queries. Any attempts to add aggregated conditions (ex. count(*)>0) to the output columns or filters that will resemble the Having clause are met with the error messages that the aggregation/aggregate functions are not allowed Please let us know if any other options were already provided in the Data Catalog that could potentially mimic the Having clause behavior.

1 Answer

Hi, This question seems to be duplicated. You can find the answer for this question in the community link [here](https://community.denodo.com/answers/question/details?questionId=9060g0000004FLLAA2&title=Denodo+Data+Catalog%3A+Having+Clause). Hope this helps.
Denodo Team
06-05-2020 17:55:30 -0400
You must sign in to add an answer. If you do not have an account, you can register here