Q&A BY TAG 'Group By'

You must sign in to ask a question. If you do not have an account, you can register here

MAX function for int field - filter for the result?
answered 23-08-2021 08:42:19 -0400

is there an easy way to set a filter to only keep the max value for a field based on two other columns? is greating a group by view with the max first and joining that to the baseview the only way to accomplish this? There are two fields that make th...

Answers: 1

max function Aggregate Group By

Denodo Data Catalog.v.7.0: Request for Having Clause
answered 06-05-2020 17:55:30 -0400

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...

Answers: 1

Having clause Data Catalog Denodo Data Catalog. Version 7.0 Group By