SQL for Analytics Developer Guide

Clouds with binary code floating aboveCloud with binary code floating above

No Results

Search Tips:

  • Please consider misspellings
  • Try different search keywords
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
PDF

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.

SELECT City
FROM "Superstore"
ORDER BY City
OFFSET 5
LIMIT 3;
City
Aberdeen
Abilene
Abilene