Offset

Description

Limits the effect of the update 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

UPDATE SUPPLIERS
	SET TOP_SUPPLIER = 'YES'
	ORDER BY VOLUME_2021 DESC
	OFFSET 10 ROWS;

Snowflake

UPDATE PUBLIC.SUPPLIERS
	SET TOP_SUPPLIER = 'YES'
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. UPDATE ORDER BY OPTION **
--	ORDER BY VOLUME_2021 DESC
-- ** MSC-WARNING - MSCEWI1002 - REMOVED NEXT STATEMENT, NOT APPLICABLE IN SNOWFLAKE. UPDATE OFFSET OPTION **
--	OFFSET 10 ROWS
	              ;
  1. MSCEWI1002: Removed next statement, not applicable in SnowFlake

Last updated

Was this helpful?