Antiselect Function Example | Teradata Vantage - Antiselect Example: Column Range - Analytics Database

Antiselect Input

The input table is antiselect_test, as in Antiselect Example: No Column Ranges.

Antiselect SQL Call with Column Range

SELECT * FROM Antiselect (
  ON antiselect_test
  USING
  Exclude ('id', '[2:3]', 'custname:prodcat')
) AS dt ORDER BY 1, 4;

Antiselect Output with Column Range