OFFSET Clause

By default, a SQL query retrieves every row in your dataset. Use the optional WHERE clause to restrict your query results to a conditional expression.

OFFSET takes the syntax OFFSET {{start}}. Start refers to the number of rows to skip before returning rows.

This example skips over rows 1-5. It returns the three subsequent rows, 6-8.

1SELECT City
2FROM "Superstore"
3ORDER BY City
4OFFSET 5
5LIMIT 3;

j

Introducing SQL for CRM Analytics

Quick Start: Run Your First Query

SQL vs SAQL

SQL Statements

SELECT Clause

FROM Clause

WHERE Clause

Boolean Expressions in SELECT Clause

GROUP BY Clause

GROUP BY ROLLUP

GROUPING()

HAVING Clause

ORDER BY Clause

LIKE Clause

BETWEEN Operator

LIMIT Clause

FETCH Clause

OFFSET Clause

CASE Statements

COALESCE()

NULLIF()

UNION Operator

Subquery

Window Functions

Date Functions

Aggregate Functions

Math Functions

String Functions and Operators

Release Notes

Previous Versions