Limit

Keyword LIMIT

Limit the number of records from result set.

Syntax:

    SELECT ... LIMIT number FETCH number

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