WHERE Clause - Teradata Database - Teradata Vantage NewSQL Engine
SQL Data Manipulation Language
- Product
- Teradata Database
- Teradata Vantage NewSQL Engine
- Release Number
- 16.20
- Published
- March 2019
- Language
- English (United States)
- Last Update
- 2019-05-03
- dita:mapPath
- fbo1512081269404.ditamap
- dita:ditavalPath
- TD_DBS_16_20_Update1.ditaval
- dita:id
- B035-1146
- lifecycle
- previous
- Product Category
- Teradata Vantage™
-
condition
- The predicate that specifies the row to be updated:
- If the UPDATE target is a SET table with a UPI, then only one row can be updated per request.
- If the UPDATE target is a SET table with a NUPI or a MULTISET table, then multiple rows can be updated per request.
-
table_name_2
- Name of the table or queue table in which the row set is to be inserted, or the name of the view through which the base table is accessed.
- This name must match the name specified for table_name_1.