Database Guide


Creating a SELECT statement - example 2

To create the example SQL SELECT statement

SELECT EMPLOYEE.JOBCODE, COUNT(*)
   FROM EMPLOYEE
   GROUP BY EMPLOYEE.JOBCODE
   HAVING MIN(EMPLOYEE.AGE) > 40

do the following:

  1. On the Multi-Row Query - Settings window, do the following:
    1. In the Connection alias field, select the connection specification for the database that contains both the EMPLOYEE and WAGES tables.
    2. In the Access set field, select the access set you want the SELECT statement to be created in.
    3. On the Query Spec tab, select the Create push button.
  2. On the SELECT Details window, do the following:
    1. Specify the example SELECT statement.
    2. Select Apply.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]