Offset

Description

Limits the effect of the delete by skipping 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 OFFSET 1 ROW

Snowflake

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

Last updated

Was this helpful?