Limit

Slices the binding-tuple stream by row position (take / skip / half-open slice).

Limit N takes the first N rows in scan order.

SQL

create table T;

insert into T ({x: 1}, {x: 2}, {x: 3}, {x: 4}, {x: 5});

select * from T limit 2;

Result

[
  { "x": 1 },
  { "x": 2 }
]

Limit 0 emits no rows.

SQL

create table T;

insert into T ({x: 1}, {x: 2});

select * from T limit 0;

Result

[]

Limit greater than the row count returns all rows.

SQL

create table T;

insert into T ({x: 1}, {x: 2});

select * from T limit 10;

Result

[
  { "x": 1 },
  { "x": 2 }
]

Limit N.. skips the first N rows and keeps the rest.

SQL

create table T;

insert into T ({x: 1}, {x: 2}, {x: 3}, {x: 4}, {x: 5});

select * from T limit 2..;

Result

[
  { "x": 3 },
  { "x": 4 },
  { "x": 5 }
]

Skipping past the end yields no rows.

SQL

create table T;

insert into T ({x: 1}, {x: 2}, {x: 3});

select * from T limit 5..;

Result

[]

Limit 0.. skips nothing and returns all rows.

SQL

create table T;

insert into T ({x: 1}, {x: 2}, {x: 3});

select * from T limit 0..;

Result

[
  { "x": 1 },
  { "x": 2 },
  { "x": 3 }
]

Limit N..M is half-open over indices [N, M).

SQL

create table T;

insert into T ({x: 1}, {x: 2}, {x: 3}, {x: 4}, {x: 5});

select * from T limit 1..3;

Result

[
  { "x": 2 },
  { "x": 3 }
]

A slice with M == N emits nothing.

SQL

create table T;

insert into T ({x: 1}, {x: 2}, {x: 3}, {x: 4}, {x: 5});

select * from T limit 3..3;

Result

[]

A slice whose end runs past the data takes through the last row.

SQL

create table T;

insert into T ({x: 1}, {x: 2}, {x: 3}, {x: 4});

select * from T limit 1..10;

Result

[
  { "x": 2 },
  { "x": 3 },
  { "x": 4 }
]

Limit slices the post-where stream, not the raw scan.

SQL

create table T;

insert into T ({x: 1}, {x: 2}, {x: 3}, {x: 4});

select * from T where T.x > 1 limit 2;

Result

[
  { "x": 2 },
  { "x": 3 }
]

Limit applies to a scalar projection.

SQL

create table T;

insert into T ({x: 1}, {x: 2}, {x: 3});

select T.x from T limit 2;

Result

[
  1,
  2
]