Sub-SELECT

A Sub-SELECT selects columns (or expressions containing columns) from the given table-returning expression.

Syntax

(SELECT <SELECT-expressions> FROM <table expression> [WHERE <WHERE-clause>])

Applies to

A table-returning expression that includes <table column reference> and functions that return a table.

Return Type

<table expression>

Remarks

An optional WHERE clause can be used to filter returned rows.