Open topic with navigation

Create a WHERE Clause

Steps

1. Access the Design workspace for the query within which you want to create a WHERE clause.
2. In the Conditions section, make sure the Show Totals check box is selected.
3. In the Total cell of the desired field, in the drop-down list, select Where.

4. Access the Expression Builder window from the Criteria or Or cells, enter the necessary parameters, and then select Done.

   Note: Make sure to clear the Include and Display check boxes in the column in which you want to create a WHERE clause.

Results

• The WHERE clause is generated in the SQL code.

• If you want to modify the clause, you can do so in the Expression Builder window, or you can modify the SQL code directly.

Copyright © 2018 General Electric Company. All rights reserved.