Specify the maximum number of rows returned

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：1分

    • 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
    注:
    If running the Interactive SQL console from a shortcut, you must modify the shortcut Target to include the -maxrows parameter with the desired value.
    iSQL shortcut properties