WHERE Clause Enhancements - Teradata Vantage - Analytics Database

DATASET Data Type
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
bka1628112240653.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ekk1458586304878
lifecycle
latest
Product Category
Teradata Vantage™

With dot notation, users can compare search results for a JSON or DATASET type against a single operand. A list of results can be compared against a single operand using overloaded versions of the ANY/ALL/SOME clauses of the WHERE clause.