Limit the number of records from result set.

Syntax:

SELECT ...LIMITnumber FETCHnumber

For example, select 20 records starting from record number 5

alasql('SELECT * FROM Cities ORDER BY Name LIMIT 20 FETCH 5');

See also:TOP,FETCH