7.30 Internal derived tables

This section gives examples of the use of internal derived tables and explains the rules for derived table expansion.

Organization of this section

• 7.30.1 Examples of using internal derived tables

• 7.30.2 Derived queries and derived query names

• 7.30.3 Rules for derived table expansion

• 7.30.4 Conditions under which derived table expansion is not performed

• 7.30.5 Summary of when derived table expansion is performed

• 7.30.6 When the scalar function CONVERT is added to an internal derived table

To Page Top