How do I limit the number of results in a query, for example in the SQL query "SELECT * FROM Orders LIMIT 30"

I'm using the Query builder and can't see how to add the limit.

Thanks
Bruce

Hi Bruce, for setting limits, please use paged query. Normal queries do not have any limits.

Thanks Teodor

How do I use a paged query? Did a search for the term on DMX website but got no results. Is there a tutorial for this somewhere?

Well, just add a "database paged query" in server connect instead of "database query".

Perfect!

Thanks Teodor