Fetch Clause

As of 2023, LIMIT is not in the SQL standard.

The LIMIT … OFFSET clause takes the form LIMIT <N> OFFSET <M> and returns the first N binding tuples of its input collection, skipping the first M if an OFFSET is specified.

PartiQL allows specifying an OFFSET value without a LIMIT value.