Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | MashZone NextGen Analytics | RAQL Queries | Having Clause to Filter Groups
 
Having Clause to Filter Groups
The Having clause allows you to filter the rows in the query results based on aggregate caculations when the query includes a Group By clause. The example shown here returns rows for each grouped stock symbol only if the average open price is greater than 100:
You can use the same comparisons in Having clauses as you can in Where clauses.

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release