HAVING clause
To specify the example HAVING clause
(MAX(WAGES.SALARY) > 3000) AND NOT (EMPLOYEE.JOBCODE = 34)
do the following:
1. In the Left operand field, select WAGES.SALARY from the list.
2. From the Unary operator pull-down menu, select Left operand > MAX(x).
3. In the Operator field, select > from the list.
4. In the Right operand field, type 3000.
5. Select Add to operand lists.
6. In the Left operand field, select EMPLOYEE.JOBCODE from the list.
7. In the Operator field, select = from the list.
8. In the Right operand field, type 34.
9. Select Add to operand lists.
10. In the Left operand field, select (MAX(WAGES.SALARY) > 3000) from the list.
11. In the Operator field, select AND from the list.
12. In the Right operand field, select (EMPLOYEE.JOBCODE = 34) from the list.
13. From the Unary operator pull-down menu, select Right operand > NOT x.
Last modified date: 01/29/2015