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"

To Page Top