Offset Clause
Description
Sets the number of rows to skip.
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 - Offset row-count
IBM DB2
SELECT * FROM Product OFFSET 3 ROW;
/* or */
SELECT * FROM Product OFFSET 3 ROWS;
Snowflake
SELECT * FROM Product LIMIT NULL OFFSET 3;
Resulting Tables
IBM Db2
Snowflake
Pattern 2 - Limit X
IBM DB2
SELECT * FROM Product LIMIT 3;
Snowflake
SELECT * FROM Product LIMIT 3;
Resulting Tables
IBM Db2
Snowflake
Pattern 1 - Limit X Offset Y
IBM DB2
SELECT * FROM Product LIMIT 3 OFFSET 2;
Snowflake
SELECT * FROM Product LIMIT 3 OFFSET 2;
Resulting Tables
IBM Db2
Snowflake
Pattern 1 - Limit X,Y
IBM DB2
SELECT * FROM Product LIMIT 3,2;
Snowflake
SELECT * FROM Product OFFSET 3 ROWS FETCH NEXT 2 ROWS ONLY;
Resulting Tables
IBM Db2
Snowflake
Last updated
Was this helpful?