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
Last updated
Was this helpful?