Database Guide
To specify the example SQL SELECT statement
SELECT EMPLOYEE.JOBCODE, COUNT(*)
FROM EMPLOYEE
GROUP BY EMPLOYEE.JOBCODE
HAVING MIN(EMPLOYEE.AGE) > 40
do the following:
- In the Query name field, type a name for the SELECT
statement.
- In the Description field, type a description for the SELECT
statement.
- In the Tables/views list, select EMPLOYEE.
- In the Columns list, select
EMPLOYEE.JOBCODE.
- From the Computed columns pop-up menu, select
Create.
- On the Computed Column Details window, do the following:
- From the Unary operator pull-down menu, select
COUNT(*).
- Select Apply
- In the Computed columns list, select
COUNT(*).
- From the Clause pull-down menu, select GROUP
BY.
- On the GROUP BY Details window, do the following:
- In the Columns list, select
EMPLOYEE.JOBCODE.
- Select Apply.
- From the Clause pull-down menu, select
HAVING.
- On the HAVING Details window, do the following:
- In the Left operand field, select
EMPLOYEE.AGE 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 40.
- Select Apply.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]