---
schema_version: "1"
id: 9701ede8589a98f206d96c3be474f6f8e0207dab66a9534291f6376be803cd6d
title: OFFSET n
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/platform/salesforce-soql-sosl/guides/soql-sosl/sforce-api-calls-sosl-offset.md
canonical_url: https://developer.salesforce.com/docs/platform/salesforce-soql-sosl/guide/sforce-api-calls-sosl-offset.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 85129cc19f8fa3ae5f00f41ad8be028d6e029e0de615c5fdf0e33151ff720ce7
products:
  - SOQL and SOSL Reference
  - Platform Developer Content
---

# OFFSET n

When expecting many records in a query’s results, you can display the results in multiple pages by using the `OFFSET` clause in a SOSL query. For example, you can use `OFFSET` to display records 51 to 75 and then jump to displaying records 301 to 350. Using `OFFSET` is an efficient way to handle large results sets.

Use the optional `OFFSET` to specify the starting row offset into the result set returned by your query. Because the offset calculation is done on the server and only the result subset is returned, using `OFFSET` is more efficient than retrieving the full result set and then filtering the results locally. `OFFSET` can be used only when querying a single object. `OFFSET` must be the last clause specified in a query. `OFFSET` is available in API version 30.0 and later.

```soql
FIND {conditionExpression} RETURNING objectType(fieldList ORDER BY fieldOrderByList
LIMIT number_of_rows_to_return
OFFSET number_of_rows_to_skip)
```

As an example, if a query normally returned 50 rows, you could use `OFFSET 10` in your query to skip the first 10 rows:

```soql
FIND {test} RETURNING Account(id LIMIT 10 OFFSET 10)
```

The result set for the preceding example would be a subset of the full result set, returning rows 11 through 20 of the full set.

## Considerations When Using `OFFSET`

Consider these points when using `OFFSET` in your queries:

- The maximum offset is 2,000 rows. Requesting an offset greater than 2,000 will result in a `System.SearchException: SOSL offset should be between 0 to 2000` error.
- We recommend using a `LIMIT` clause in combination with `OFFSET` if you need to retrieve subsequent subsets of the same result set. For example, you could retrieve the first 100 rows of a query using the following:

  ```soql
  FIND {test} RETURNING Account(Name, Id ORDER BY Name LIMIT 100)
  ```

  You could then retrieve the next 100 rows, 101 through 200, using the following query:

  ```soql
  FIND {test} RETURNING Account(Name, Id ORDER BY Name LIMIT 100 OFFSET 100)
  ```

- When using `OFFSET`, only the first batch of records will be returned for a given query. If you want to retrieve the next batch, you’ll need to re-execute the query with a higher offset value.
- Consecutive SOSL requests for the same search term but with a different OFFSET aren’t guaranteed to return a different subset of the same data if the data being searched has been updated since the previous request.
- The `OFFSET` clause is allowed in SOSL used in SOAP API, REST API, and Apex.