Description
The SELECT statement returns values from one or more tables or views in the form of a single result table. Using the various clauses of the SELECT statement, you can specify:
• Qualifications for the values in the result table
• Sorting and grouping of the values in the result table
This statement description presents details of the SELECT statement in interactive OpenSQL (ISQL). In ISQL the results of a query are displayed on your terminal. In embedded OpenSQL (ESQL), results are returned in host language variables. For details about using the SELECT statement in ESQL, see
Select (embedded) (see page
Select (embedded)).
The following sections describe the clauses of the SELECT statement, explain how to create simple queries, and explain how the results of a query are obtained.