16.20 - Antiselect Example: Column Range - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ - NewSQL Engine Analytic Functions

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
July 2019
Content Type
Programming Reference
Publication ID
B035-1206-162K
Language
English (United States)

Input

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

SQL Call

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

Output

sno qty sales disct dmode
1 6 2.61540000000000E 002 0.04 Regular Air
49 49 1.01230000000000E 004 0.07 Delivery Truck
50 27 2.44570000000000E 002 0.01 Regular Air
80 30 4.96576000000000E 003 0.08 Regular Air
85 19 3.94270000000000E 002 0.08 Regular Air
86 21 1.46690000000000E 002 0.05 Regular Air
97 12 9.35400000000000E 001 0.03 Regular Air