4.4.4 SELECT clause

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

(1) Format

SELECT-clause::=SELECT[Figure]{selection-list|*}

(2) Function

Specifies the items to be output for the searched result (select expression) and retrieves the select expression as a relation.

(3) Operands

selection-list

For details about specifying a selection list, see 4.4.10 Selection list.

*

Outputs all columns of the relation.

This returns all columns in the order specified in the FROM clause of the relation expression. The column order in each relation is the order specified in the schema specification character strings when the stream was defined, or in the selection list when the query was defined.

(4) Syntax rules

None.

(5) Notes

None.

(6) Usage example

Outputs all data of relation s1. The underlined part indicates the SELECT clause.

REGISTER QUERY q1 SELECT * FROM s1[ROWS 10];