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