A hierarchical query is a type of SQL query that handles hierarchical model data. Standard SQL specifies hierarchical queries by way of recursive common table expressions (CTEs). Recursive CTEs are supported by systems including IBM DB2, Microsoft SQL Server, Firebird 2.1 and PostgreSQL 8.4. An alternative syntax is the non-standard CONNECT BY construct.

PropertyValue
dbpprop:abstract
  • A hierarchical query is a type of SQL query that handles hierarchical model data. Standard SQL specifies hierarchical queries by way of recursive common table expressions (CTEs). Recursive CTEs are supported by systems including IBM DB2, Microsoft SQL Server, Firebird 2.1 and PostgreSQL 8.4. An alternative syntax is the non-standard CONNECT BY construct.
  • 再帰クエリ (英: recursive query もしくは 階層クエリ (英: hierarchical query は、階層構造を持つデータに対して問い合わせを行う SELECT ステートメントである。
dbpprop:date
  • February 2009
dbpprop:discuss
  • Talk:Common table expressions Merge proposal
dbpprop:reference
dbpprop:wikiPageUsesTemplate
rdfs:comment
  • A hierarchical query is a type of SQL query that handles hierarchical model data. Standard SQL specifies hierarchical queries by way of recursive common table expressions (CTEs). Recursive CTEs are supported by systems including IBM DB2, Microsoft SQL Server, Firebird 2.1 and PostgreSQL 8.4. An alternative syntax is the non-standard CONNECT BY construct.
  • 再帰クエリ (英: recursive query もしくは 階層クエリ (英: hierarchical query は、階層構造を持つデータに対して問い合わせを行う SELECT ステートメントである。
rdfs:label
  • Hierarchical query
  • 再帰クエリ
owl:sameAs
skos:subject
foaf:page
is dbpprop:redirect of