column-specification-list::=column-specification[,column-specification-list]
Specifies one or more columns.
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.
For details about the syntax rules for the column specification list, see 3.2.5(2) Column specification.
For notes on the column specification list, see 3.2.5(2) Column specification.
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;