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

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantageā„¢

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

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