Open topic with navigation

Create a HAVING Clause

Steps

1. Access the Design workspace for the query within which you want to create a HAVING clause.
2. In the Conditions section, make sure the Show Totals check box is selected.
3. In the Total cell of the desired field, in the drop-down list, select any option other than Where.
4. Access the Expression Builder window from the Criteria or Or cells, enter the necessary parameters, and then select Done.

Results

• The HAVING clause is generated in the SQL code.

• If you want to modify the clause, you can do so in the Expression Builder window, or you can modify the SQL code directly.

Copyright © 2018 General Electric Company. All rights reserved.