topic Re: SQL command limit in query builder? in Discussions

SQL command limit in query builder?

Feli — Fri, 09 Jun 2023 00:35:01 GMT

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.

Re: SQL command limit in query builder?

guillaumebugnon — Thu, 17 Jun 2021 15:30:42 GMT

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

Re: SQL command limit in query builder?

Feli — Fri, 18 Jun 2021 05:47:18 GMT

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.