To add an SQL LIMIT clause to a query, enter it in the
clause text box. For example, enter "Limit 200" to limit the number of retrieved rows to 200. Add a space after the WHERE information and then enter the SQL LIMIT. Else, enter the SQL LIMIT information on a new line.("Limit" can be in upper, lower, or mixed case.) By default, 100 rows are returned. If your
requires more than 100, you must add this clause. However, a read-only object list has a limit of 100 rows, even if you set a query associated with it to more than 100.