In this topic you learn how to add a single criteria to the query in order to limit the query results to a specified value.

In this example the query will display the employees whose highest education level is Doctorate (Academic). To do this you will use the "equal to" Condition Type.

Click the Add Criteria button for HIGHEST_EDUC_LVL.

Click the drop-down arrow for *Condition Type and select the "equal to" option.

Note: The "equal to" Condition Type finds data having a value that matches the specific value.

Note: The Expression 2 Type defaults to Constant when "equal to" is selected.

Click the Select Constant From List button to access the list of education level types and define the desired constant.

Click the Select Constant link for "J" Doctorate (Academic).

Note: The Criteria tab now indicates HIGHEST_EDUC_LVL = J

Note: The query results display only those employees (whose records you may access) with a highest education level of J-Doctorate (Academic).

This completes Add a Single Criteria.

Click the drop-down arrow for *Condition Type and select the "equal to" option.

Note: The "equal to" Condition Type finds data having a value that matches the specific value.