Picks rows based on their position.
take {n|range}
See Ranges for more details on how ranges work.
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