Statements (23)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
SQL feature
|
| gptkbp:abbreviation |
gptkb:CTE
|
| gptkbp:allows |
temporary result set
|
| gptkbp:alternativeTo |
subqueries
derived tables |
| gptkbp:canBe |
recursive
non-recursive |
| gptkbp:canReferTo |
other CTEs in the same WITH clause
|
| gptkbp:definedIn |
SELECT statement
|
| gptkbp:hasSyntax |
WITH clause
|
| https://www.w3.org/2000/01/rdf-schema#label |
Common Table Expression
|
| gptkbp:introducedIn |
gptkb:SQL:1999
|
| gptkbp:scope |
single SQL statement
|
| gptkbp:supportedBy |
gptkb:Oracle
gptkb:MySQL gptkb:SQLite gptkb:PostgreSQL gptkb:SQL_Server |
| gptkbp:usedFor |
recursive queries
improving query readability |
| gptkbp:usedIn |
SQL
|
| gptkbp:bfsParent |
gptkb:CTE
|
| gptkbp:bfsLayer |
7
|