4.4.13 Column specification list

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

(1) Format

column-specification-list::=column-specification[,column-specification-list]

(2) Function

Specifies one or more columns.

(3) Operands

column-specification

For details about column specification, see 3.2.5(2) Column specification.

The number of columns that can be specified is in the range from 1 to 255.

(4) Syntax rules

For details about the syntax rules for the column specification list, see 3.2.5(2) Column specification.

(5) Notes

For notes on the column specification list, see 3.2.5(2) Column specification.

(6) Usage example

Groups columns b and c of relation s1 and outputs the data in columns a, b, and c. The underlined part indicates the column specification list.

REGISTER QUERY q1 SELECT SUM(s1.a) AS a1, s1.b, s1.c FROM s1[ROWS 100]
                 GROUP BY s1.b, s1.c;