Selecting those rows that satisfy a condition specified for a particular column is called a retrieval. You can also join and search two or more tables based on the values of a specific column and obtain a single set of retrieval results.

This section describes retrieval from one or more tables.

Organization of this section

2.3.1 Retrieval from a single table

2.3.2 Retrieval from multiple tables

2.3.3 Retrieval of a table with FIX attribute