Limit

Jump to bottom

Mathias Rangel Wulff edited this page Jun 12, 2015 · 3 revisions

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

© 2014-2023, Andrey Gershun & Mathias Rangel Wulff

Please let us know if something could be described better by submitting an issue

Quick links

Clone this wiki locally