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, created_at}
take 101..110

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