Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
SELECT statementUse the SELECT statement to retrieve values from a database or from an SPL or collection variable. A SELECT operation is called a query.
Hierarchical ClauseThe Hierarchical clause sets the conditions for recursive queries on a table object in which a hierarchy of parent-child dependencies exists among the rows. SELECT statements that include this clause are called hierarchical queries.
START WITH ClauseThe optional START WITH clause specifies a condition. The row that satisfies this condition becomes the root for beginning the recursive operations of the CONNECT BY clause in hierarchical queries.

START WITH Clause

The optional START WITH clause specifies a condition. The row that satisfies this condition becomes the root for beginning the recursive operations of the CONNECT BY clause in hierarchical queries.

The START WITH clause is an extension to the ANSI/ISO standard for SQL. This syntax fragment is part of the Hierarchical Clause.

START WITH Clause

Notes:

¹ See Condition

Usage

The START WITH clause specifies a search condition that the CONNECT BY clause uses for the first iteration of its recursive actions. If you omit the START WITH clause, the CONNECT BY clause treats every row as the root of the hierarchy for the initial set of intermediate results.