---
title: "LIMIT Clause"
url: https://docs.catalyst.zoho.com/en/cloud-scale/help/zcql/limit/
description: "ZCQL is Catalyst's own query language modelled after familiar query languages that you can use to query your app's database efficiently."
last_updated: 2023-08-28T12:42:09Z
service: Cloud Scale
type: general
---

### LIMIT Clause

The `LIMIT` clause limits the number of data records that are displayed in the result set of a search query. It contains the following properties:

1. **`OFFSET`: OFFSET defines the starting index of the result, i.e., the first record's position that will be displayed in the result.
2. `VALUE`**: VALUE defines the number of records to be retrieved from the starting index, i.e., the `OFFSET`.

The `LIMIT` clause identifies the `OFFSET` index and then displays the number of records as specified in the `VALUE` from the `OFFSET` index. You can also just specify the value without specifying the offset, when the starting index is the first record.

The `LIMIT` clause is only used when a specific number of records is to be displayed. It is used towards the end of the query after all the other clauses and statements.

The basic syntax for using the `LIMIT` clause with a `SELECT` statement is:

```sql
SELECT column_name(s) FROM parent_table_name LIMIT OFFSET, VALUE
```

**Example**:

To view a list of the movies from the _Movies_ table consisting of up to three records from the second starting index execute the following query:

```sql
SELECT * FROM Movies LIMIT 1,3 
```

It will generate the following output:

<table class="content-table">
<thead>
<tr>
<th><strong>MovieID</strong></th>
<th><strong>MovieName</strong></th>
<th><strong>ShowDate</strong></th>
<th><strong>ShowTime</strong></th>
<th><strong>TheaterID</strong></th>
</tr>
</thead>
<tbody>
<tr>
<td>2057</td>
<td>Ant-Man and the Wasp</td>
<td>2018-07-13</td>
<td>14:20:00</td>
<td>052</td>
</tr>
<tr>
<td>2058</td>
<td>Hotel Transylvania 3: Summer Vacation</td>
<td>2018-07-14</td>
<td>17:00:00</td>
<td>052</td>
</tr>
<tr>
<td>2059</td>
<td>Skyscraper</td>
<td>2018-07-14</td>
<td>21:30:00</td>
<td>053</td>
</tr>
</tbody>
</table>