Limit

Keyword LIMIT

Limit the number of records from result set.

Syntax:

    SELECT ... LIMIT number|param FETCH number

For example, select 20 records starting from record number 5

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

See also: TOP, FETCH