Fetch

Description

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

UPDATE SUPPLIERS
	SET TOP_SUPPLIER = 'YES'
	ORDER BY VOLUME_2021 DESC
	FETCH NEXT 10 ROWS ONLY;

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 FETCH OPTION **
--	FETCH NEXT 10 ROWS ONLY
	                       ;
  1. MSCEWI1002: Removed next statement, not applicable in SnowFlake

Last updated

Was this helpful?