Scope of the row_count Limit Type

A resource limit that restricts row count applies only to single queries, not to cumulative rows returned by a query batch or transaction.

Related concepts
Determining the Scope of Resource Limits