Take

Picks rows based on their position.

take {n|range}

See Ranges for more details on how ranges work.

Examples

from employees
take 10

SELECT
  *
FROM
  employees
LIMIT
  10

from orders
sort [-value, date]
take 101..110

SELECT
  *
FROM
  orders
ORDER BY
  value DESC,
  date
LIMIT
  10 OFFSET 100