You define selection criteria to selectively retrieve the data that you want. Selection criteria refine your query by specifying conditions that the retrieved data must meet. For example, you can specify that the system retrieve only those phone numbers with a certain area code instead of all phone numbers.

 

Upon completion of this lesson, you will be able to:

• Describe selection criteria.

• Describe condition types.

• Describe comparison values.

• Describe effective-date criteria.

• Describe multiple criteria.

• Define criteria.

• View and edit selection criteria.

• Edit criteria properties.

• Select a constant value.

• Build a list of values.

• Describe prompts.

• Define prompts.

• Add prompts to an expression list.

• Add comparison values to an expression list.

• Define HAVING criteria.

• Define expressions.


Table of Contents