Specifies a result table. A result table is an intermediate table
    of values derived from columns and rows of one or more tables or
    views that meet conditions specified by a select expression.
    The tables or views that the columns and rows come from are
    identified in the FROM clause of the statement.

    The basic element of a SELECT statement is called a select
    expression. The Select_Expressions HELP topic describes select
    expressions in detail.

    To retrieve rows of a result table in host language programs, you
    must use the DECLARE CURSOR statement or a special form of SELECT
    statement called a singleton select. See the SELECT Singleton_
    Select statement for more information about a singleton select.

    SQL evaluates the clauses of a SELECT statement in the following
    order:

    1. FROM

    2. WHERE

    3. GROUP BY

    4. HAVING

    5. Select list

    6. ORDER BY

    7. OFFSET

    8. LIMIT TO (or FETCH FIRST)

    9. OPTIMIZE

    After each of these clauses, SQL produces an intermediate result
    table that is used in evaluating the next clause.