BigMemory 4.3.9 | Product Documentation | BigMemory Max Developer Guide | Searching with BigMemory SQL | SQL Syntax and Examples | LIMIT Clause
 
LIMIT Clause
The LIMIT clause can be used to restrict the number of results returned by the search query. Ordinarily, the LIMIT clause is used with an ORDER BY clause to get the top results.
select * from Person where age < 80 limit 100
The LIMIT clause takes a single integer argument to restrict the result set with this general form:
limit <integer>
Example of Limiting Search Results
select age, zip from Person where ((age > 100 and zip = 20144) or time > 10)
order by age asc limit 10