Database Guide
To specify the example HAVING clause
(MAX(WAGES.SALARY) > 3000) AND NOT (EMPLOYEE.JOBCODE = 34)
do the following:
- In the Left operand field, select
WAGES.SALARY from the list.
- From the Unary operator pull-down menu, select Left
operand > MAX(x).
- In the Operator field, select > from the
list.
- In the Right operand field, type 3000.
- Select Add to operand lists.
- In the Left operand field, select
EMPLOYEE.JOBCODE from the list.
- In the Operator field, select = from the
list.
- In the Right operand field, type 34.
- Select Add to operand lists.
- In the Left operand field, select
(MAX(WAGES.SALARY) > 3000) from the list.
- In the Operator field, select AND from the
list.
- In the Right operand field, select
(EMPLOYEE.JOBCODE = 34) from the list.
- From the Unary operator pull-down menu, select Right
operand > NOT x.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]