17.05 - Antiselect Syntax Elements - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1206-170K
Exclude
Specify the names of the input table columns to exclude from the output table. Column names must be valid object names, which are defined in Teradata Vantage™ - SQL Fundamentals, B035-1141.
The exclude_column is a column name. This is the syntax of exclude_column_range:
'start_column:end_column' [, '-exclude_in-range_column' ]

The range includes its endpoints.

The start_column and end_column can be:
  • Column names (for example, 'column1:column2')

    Column names must contain only letters in the English alphabet, digits, and special characters. If a column name includes any special characters, surround the column name with double quotation marks. For example, if the column name is a*b, specify it as "a*b". A column name cannot contain a double quotation mark.

  • Nonnegative integers that represent the indexes of columns in the table (for example, '[0:4]')

    The first column has index 0; therefore, '[0:4]' specifies the first five columns in the table.

  • Empty. For example:
    • '[:4]' specifies all columns up to and including the column with index 4.
    • '[4:]' specifies the column with index 4 and all columns after it.
    • '[:]' specifies all columns in the table.

The exclude_in-range_column is a column in the specified range, represented by either its name or its index (for example, '[0:99]', '-[50]', '-column10' specifies the columns with indexes 0 through 99, except the column with index 50 and column10).

Column ranges cannot overlap, and cannot include any specified exclude_column.