The SET MAXROW statement restricts the estimated number of rows that can be returned by subsequent queries. Value must be less than or equal to the session's value for query_row_limit. If no query_row_limit is set, there is no limit on the number of rows returned.

When MAXROW is set, it remains in effect until another SET MAXROW or SET NOMAXROW statement is issued, or the session terminates.

For more information, see query_row_limit in the description of GRANT (privilege).