Where Clause
Description
Specifies a condition that selects the rows to be deleted. The clause can be omitted, a search condition specified, or a cursor named. If the clause is omitted, all rows of the table or view are deleted.
All the grammar specified in this Where clause of DB2 is ANSI compliant, equivalent to Snowflake, and is therefore translated as is by SnowConvert.
Click here to navigate to the IBM DB2 docs page for this syntax.
Grammar Syntax
Sample Source Patterns
IBM DB2
Snowflake
Last updated
Was this helpful?