SQL command limit in query builder?

[#1]

In normal SQL, I can limit the number of returned results using the function LIMIT. Is there a similar function in the Query Builder available?

When querying large data bases, it would be nice if I could limit the number of results to avoid overloading JMP when selecting the filters unwisely.

[#2]

Hello,

Do you need to limit data into the preview? If yes, you have some settings into File > Preferences menu.

'Maximum number of rows for previews' should be similar to LIMIT.

Guillaume

[#3]

No, I truly want to limit the results queried to, e.g., not more than 1000. Meaning that in the SQL of the query builder the function LIMIT 1000 will appear below this.