DARTS : Having

The Having page in Query Manager allows us to filter the output using the aggregate function. It is similar to the Criteria page, but it is used for aggregate columns. You must have an aggregated field if you want to use it, such as COUNT, SUM, MIN, or MAX.

Similarly, when you filter the aggregates field, the field will be added under the ‘Having’ tab automatically.

having tab

Example:

Find institutions that have more than 5000 students
results

Create an aggregate field. In this case, COUNT(A.EMPLID) was created in the expression as enrollment field. (Please see the Creating Expressions page for more information about expressions.)
Click the small funnel icon for the expression
Change Condition Type to "greater than" and enter the constant. Click OK
When you go to the Having page, the criteria is automatically added on the page (not on the Criteria page).
Run the query to check the data

Join PS Query Group!

Have you joined UMS PS Query User Group yet? You can ask questions or share tips and more.

HELP IS AT HAND!

Question, comment, critique? We are here to help and we strive to make our site a comprehensive, user friendly experience. Contact us at DARTS@maine.edu.

DARTS : Having

Example:

Attachments: