---
category: [Administration & Integrations, Platform and Product Extensions, Platform and Product Extensions/Integration, Administration & Integrations/Custom Integrations & Apps]
keyword: [Extend, Workday Query Language, WQL]
nav: wcp_docs
parent_url: /wcp_docs/
title: LIMIT
layout: subsection
---

<a id="d400e263"></a>
Returns records up to the maximum number that you specify.

## <a id="d400e269"></a>Syntax

```
LIMIT integer
```

## <a id="d400e278"></a>Arguments

<table><thead><tr><th>Argument</th><th>Description</th></tr></thead><tbody><tr><td><code><i>integer</i></code></td><td>The maximum number of records to return.</td></tr></tbody></table><br/>

## <a id="d400e311"></a>Example

Returns the full names for the first 10 records in the <b>allWorkers</b> data source:

```
SELECT fullName
FROM allWorkers
ORDER BY fullName ASC
LIMIT 10
```

## <a id="d400e326"></a>Limitations

-   `LIMIT` value must be greater than zero and less than 1 million.
-   Because the `LIMIT` clause first retrieves the entire set of results before returning the number of records you specify, using this clause doesn’t improve the performance of your query.