Fetch Clause

Description

Sets a maximum number of rows to be retrieved.

Click here 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

SELECT * FROM Product FETCH First Row ONLY;
/* or */
SELECT * FROM Product FETCH First Rows ONLY;
/* or */
SELECT * FROM Product FETCH Next Row ONLY;
/* or */
SELECT * FROM Product FETCH Next Rows ONLY;

Snowflake

SELECT * FROM Product FETCH NEXT 1 ROW ONLY;

Resulting Tables

IBM DB2	Snowflake

Pattern 2 - Fetch with row count

IBM DB2

SELECT * FROM Product FETCH First 2 Row ONLY;
/* or */
SELECT * FROM Product FETCH First 2 Rows ONLY;
/* or */
SELECT * FROM Product FETCH Next 2 Row ONLY;
/* or */
SELECT * FROM Product FETCH Next 2 Rows ONLY;

Snowflake

SELECT * FROM Product FETCH First 2 Row ONLY;
/* or */
SELECT * FROM Product FETCH First 2 Rows ONLY;
/* or */
SELECT * FROM Product FETCH Next 2 Row ONLY;
/* or */
SELECT * FROM Product FETCH Next 2 Rows ONLY;

Resulting Tables

IBM DB2	Snowflake