7.30.2 Derived queries and derived query names
A query expression body that generates a derived table is called a derived query. In addition, the name of the table derived from the derived query is called the derived query name. The derived table's derived query name is handled as a correlation name.
The derived query and derived query name are identified in each of the following examples.
- View definition
-
CREATE VIEW "V1" AS SELECT * FROM "T1" WHERE "C1">100
Derived query: underlined portion
Derived query name: "V1"
- Derived table
-
SELECT "C1","C2"*1.05 FROM (SELECT "C1","C2" FROM "T1" GROUP BY "C1","C2") "X"
Derived query: underlined portion
Derived query name: "X"
- WITH clause query
-
WITH "Q1" AS (SELECT "C1","C2" FROM "T1" GROUP BY "C1","C2") SELECT "C1","C2"*1.05 FROM "Q1"
Derived query: underlined portion
Derived query name: "Q1"