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

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama 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: Yokohama  
Updated January 30, 2025  
![](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.