4.4.10 Selection list

Organization of this subsection
(1) Format
(2) Function
(3) Operand
(4) Syntax rules
(5) Notes
(6) Usage example

(1) Format

selection-list::=select-expression[,selection-list]

(2) Function

Specifies one or more select expressions.

(3) Operand

select-expression

For details about specifying a select expression, see 4.4.11 Select expression.

The number of select expressions that can be specified is in the range from 1 to 3,000.

(4) Syntax rules

Specify a selection list following the SELECT clause.

(5) Notes

Only relation data acquired by the FROM clause can be specified in a selection list.

(6) Usage example

Outputs the data in columns a and b of relation s1. The underlined part indicates a selection list.

REGISTER QUERY q1 SELECT s1.a, s1.b FROM s1[ROWS 100];