Result Set Number Of Rows. SELECT FROM tbl LIMIT 5. This command is only valid for statements like SELECT or SHOW that return an actual result set.
SET ROWCOUNT stops processing after the specified number of rows. Numbers the output of a result set. For example LIMIT 10 would return the first 10 rows matching the SELECT criteria.
The Results Set Row Limit property is used to limit the number of rows returned from the final results set SELECT statements issued.
ROW_NUMBER and RANK are similar. To number rows in a result set you have to use an SQL window function called ROW_NUMBER. Returns the number of rows in the result set. If the report result set exceeds the limit specified in the Result Set Row Limit the report execution is terminated.