The limit in the query does affect the total number of rows returned but does not affect the number of rows pulled back at one time leading the user to have to scroll down in the result grid (or press ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback