17.05 - Antiselect Syntax Elements - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Analytic Functions

Advanced SQL Engine
Teradata Database
June 2020
Programming Reference
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.