---
category: [Administration & Integrations, Platform and Product Extensions, Platform and Product Extensions/Integration, Administration & Integrations/Custom Integrations & Apps, Platform and Product Extensions/Workday Extend]
keyword: [Extend, WQL, Limits]
nav: wcp_docs
parent_url: /wcp_docs/
title: >- 
  Reference: WQL Result Limits
layout: subsection
---

## <a id="wqlresultlimits"></a>WQL Result Limits

WQL queries return a maximum of 1 million rows. Both tenanted hosts and the Workday Cloud Platform (WCP) API Gateway (api.workday.com) support WQL requests, with these response timeout limits:

-   Tenanted hosts: 30-minute timeout.
-   WCP API Gateway: 5-minute timeout.


Refer to this table for query and `LIMIT` clause behavior.

<table><thead><tr><th>Rows Returned By Query</th><th>LIMIT Clause in WQL Query</th><th>Query Behavior</th></tr></thead><tbody><tr><td>>1 million</td><td>None</td><td>Query fails.</td></tr><tr><td>>1 million</td><td><=1 million</td><td>Query succeeds and returns a maximum of 1 million rows. You can view 10,000 rows at a time.</td></tr><tr><td><=1 million</td><td>None or <=1 million</td><td>Query succeeds and returns all rows. You can view 10,000 rows at a time.</td></tr></tbody></table><br/>

<b>Note:</b> Workday reserves the keyword `LIMIT` for both a clause and a pagination parameter. The LIMIT keyword isn't case-sensitive. We use uppercase and lowercase to help differentiate between clauses and pagination parameters.

-   Use the `LIMIT` clause to limit the number of total rows returned in a query response.
-   Use the `limit` parameter to specify how many rows to display per page of query response.


<a id="section_1"></a>
### Related Information

[Concept: Pagination of WQL Query Results](/wcp_docs/GUID-c4a11fa0-44b9-49ef-bb37-49f3b601b3bd-enHYPHENus.html)