WHERE Clause Enhancements

Teradata Vantageā„¢ DATASET Data Type

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1198-162K

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.