---
sourceDocument: Xanadu API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/api-reference

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# Specify the maximum number of rows returned

# Specify the maximum number of rows returned {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

By default, ServiceNow only
returns 100 rows of data with each iSQL query. If you need to return more rows of data, set the
maxrows parameter for the iSQL session.
To return all rows set `maxrows` to zero:  

    maxrows 0

To return more than 100 rows set `maxrows` to a higher value. For example, to return 500 rows:  

    maxrows 500

Note:  
If running the Interactive SQL console from a shortcut, you must modify the shortcut Target to include the -maxrows parameter with the desired value.