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

Database Analytic Functions

Product
Teradata® Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/wnd1589838592459.ditamap
dita:ditavalPath
Teradata_Vantage™___Advanced_SQL_Engine_Analytic_Functions.withLogo_upload_July2021/ayr1485454803741.ditaval
dita:id
B035-1206
lifecycle
previous
Product Category
Teradata Vantage™

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