ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
AntiSelect Function in Teradata - SQL ( Step by Step)
ฝัง
- เผยแพร่เมื่อ 27 พ.ค. 2024
- AntiSelect Function in Teradata: In Teradata AntiSelect function is used exclude columns from the table that you're not required. All you need to do specify the list in the exclude.
Brush your SQL Query Skills with Teradata
The Ultimate Guide for SQL Optimization
Below is just an example. Use any table to exclude columns from the Teradata.
SELECT * FROM Antiselect (
ON DWH.Products
USING
Exclude ('[0:1]','CreatedAt','UpdatedAt' )
) AS dt
MINUS
SELECT * FROM Antiselect (
ON DWH.Products_TRG
USING
Exclude ('[0:1]','CreatedAt',
'UpdatedAt' )
) AS dt;