- column_name
A set of column names drawn from the list of tables specified in the FROM clause of the SELECT request that is used in the GROUP BY clause to specify the columns by which data is to be grouped.
See Teradata Vantage™ - SQL Fundamentals, B035-1141 for the rules for naming database objects.
- column_position
The sequential numeric position of columns within the column_list clause of the SELECT statement that is used in the GROUP BY clause to specify the order by which data is to be grouped.
The sequential numeric position of columns within the column_list clause of the SELECT statement that is used in the GROUP BY clause to specify the order by which data is to be grouped.
This must be a positive integer.
Use of column_position is a Teradata extension to the ANSI SQL-2011 standard.
- expression
Any list of valid SQL expressions specified for the GROUP BY clause.
You can specify column_name, column_position, and expression either as individual entries or as a list.
Use of expression is a Teradata extension to the ANSI SQL-2011 standard.
For details about ordinary grouping sets, see SQL Data Manipulation Language.