Hierarchical and recursive queries in SQL
A hierarchical query is a type of SQL query that handles hierarchical model data. They are special cases of more general recursive fixpoint queries, which compute transitive closures. In standard SQL:1999 hierarchical queries are implemented by way of recursive (CTEs). Unlike Oracle's earlier , recursive CTEs were designed with fixpoint semantics from the beginning. Recursive CTEs from the standard were relatively close to the existing implementation in IBM DB2 version 2. Recursive CTEs are also supported by Microsoft SQL Server (since SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix version 11.50+, CUBRID, MariaDB 10.2+ and MySQL 8.0.1+. Tableau has documentation describing how CTEs can be used. TIBCO Spotfire does not support CTEs, while Oracle 11g Release
Wikipage disambiguates
CONNECT BYCONNECT BY ISCYCLECONNECT BY ISLEAFCONNECT BY ROOTCommon table expressionCommon table expressionsHierarchical and fixpoint queries in SQLHierarchical queryRecursion in SQLRecursive SQL queryRecursive WITHRecursive queries in SQLRecursive subquery factoringSYS CONNECT BY PATHSubquery factoringWITH RECURSIVEWith (SQL)
Wikipage redirect
CONNECT BYCONNECT BY ISCYCLECONNECT BY ISLEAFCONNECT BY ROOTCTECUBRIDCommon table expressionCommon table expressionsComparison of relational database management systemsDatalogFinite model theoryFirebird (database server)GraphQLHierarchical and fixpoint queries in SQLHierarchical database modelHierarchical queryHierarchyHierarchy (disambiguation)Nested set modelPostgreSQLRecursion (computer science)Recursion in SQLRecursive SQL queryRecursive WITHRecursive joinRecursive queries in SQLRecursive subquery factoringRelational algebraSQLSQL:1999SQL syntaxSQLiteSYS CONNECT BY PATHSelect (SQL)Subquery factoringTree structureTuring completenessWITH RECURSIVEWith (SQL)
Link from a Wikipage to another Wikipage
primaryTopic
Hierarchical and recursive queries in SQL
A hierarchical query is a type of SQL query that handles hierarchical model data. They are special cases of more general recursive fixpoint queries, which compute transitive closures. In standard SQL:1999 hierarchical queries are implemented by way of recursive (CTEs). Unlike Oracle's earlier , recursive CTEs were designed with fixpoint semantics from the beginning. Recursive CTEs from the standard were relatively close to the existing implementation in IBM DB2 version 2. Recursive CTEs are also supported by Microsoft SQL Server (since SQL Server 2008 R2), Firebird 2.1, PostgreSQL 8.4+, SQLite 3.8.3+, IBM Informix version 11.50+, CUBRID, MariaDB 10.2+ and MySQL 8.0.1+. Tableau has documentation describing how CTEs can be used. TIBCO Spotfire does not support CTEs, while Oracle 11g Release
has abstract
A hierarchical query is a type ...... r-defined recursive functions.
@en
Em banco de dados SQL, Common ...... CT, INSERT, UPDATE, ou DELETE.
@pt
Ієрархічний запит — тип запиту ...... тувацьких рекурсивних функцій.
@uk
Иерархический запрос - это тип ...... ательских рекурсивных функций.
@ru
再帰クエリ (英: recursive query) もしく ...... CT ステートメントである。階層構造を持つデータなどに使う。
@ja
Link from a Wikipage to an external page
Wikipage page ID
17,919,602
page length (characters) of wiki page
Wikipage revision ID
1,026,001,366
Link from a Wikipage to another Wikipage
wikiPageUsesTemplate
hypernym
comment
A hierarchical query is a type ...... CTEs, while Oracle 11g Release
@en
Em banco de dados SQL, Common ...... CT, INSERT, UPDATE, ou DELETE.
@pt
Ієрархічний запит — тип запиту ...... ції Oracle 11g Release 2 браку
@uk
Иерархический запрос - это тип ...... ательских рекурсивных функций.
@ru
再帰クエリ (英: recursive query) もしく ...... CT ステートメントである。階層構造を持つデータなどに使う。
@ja
label
Common table expression
@pt
Hierarchical and recursive queries in SQL
@en
Ієрархічні та рекурсивні запити в SQL
@uk
Иерархические и рекурсивные запросы в SQL
@ru
再帰クエリ
@ja