OFFSET

Keyword OFFSET

Syntax:

    SELECT ... OFFSET number|param

OFFSET will now skip the first N rows in a result set before starting to return any rows.

For example, skip 20 records

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

See also: FETCH, TOP