Fetch

Description

Limits the effect of the delete to a subset of the qualifying rows.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

DELETE FROM table1 FETCH NEXT 1 ROW ONLY

Snowflake

DELETE FROM
PUBLIC.table1
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. UPDATE FETCH OPTION **
--FETCH NEXT 1 ROW ONLY
  1. MSCEWI1002: Removed next statement, not applicable in SnowFlake

Last updated

Was this helpful?