---
sourceDocument: Australia API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/de-DE/api-reference

 Release :

    - australia

ft:locale :

    - de-DE

ft:publication_title :

    - Australia 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}

* Freigeben Version: Australia
* 
* Aktualisiert 12. März 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 Minute Lesedauer

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

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