Important: You do not have the latest version of Historian! You are missing out on the newest capabilities and enhanced security. For information on all the latest features, see the Historian product page. For more information on upgrades, contact your GE Digital sales agent or e-mail GE Digital Sales Support. For the most up-to-date documentation, go here.

How Do I Throttle Query Results?

The default maximum row count is 5,000. If you want to throttle the number of rows that you return in a single query, you can do one of the following:

Use the SET statement to specify the RowCount to a specific number of rows.
Use the TOP predicate to specify the top number or top percentage of rows that you want to return.
Use the MaxRecords property on the recordset object in ADO.