Fetch Clause

Description

Sets a maximum number of rows to be retrieved.

Click herearrow-up-right to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

Initial Tables

IBM DB2
Snowflake

Pattern 1 - Fetch without row count

IBM DB2

Snowflake

Resulting Tables

IBM DB2
Snowflake

Pattern 2 - Fetch with row count

IBM DB2

Snowflake

Resulting Tables

IBM DB2
Snowflake

Last updated

Was this helpful?