To specify how you want the rows in a result table to be restricted, specify a SELECT statement with a WHERE clause.
In this example, you will use the SQL Editor to create the following query:
SELECT * FROM STAFF WHERE (STAFF.DEPT > 30)
![]() | When you use SELECT *, an asterisk is the only thing other than DISTINCT that can be in the SEColumns, Computed columns, and Column sequence lists are disabled. Turn off SELECT * to re-enable them. |
Using the WHERE Details window
Now you are ready to specify the restrictions of the result table rows using a WHERE clause.
This displays the WHERE Details window, which looks like the
following. Use this window to specify how you want to restrict the rows
of the result table.
![]() | Aside from some of the choices on the Unary operator menu and in the Operator list, the SQL Editor's WHERE Details, HAVING Details, Computed Column Details, and Expression Details windows are identical, so when you learn one, you know them all. |