Take

Picks rows based on their position.

1. take (n|range)

See Ranges for more details on how ranges work.

Examples

PRQL

1. from employees
2. take 10

SQL

1. SELECT
2. *
3. FROM
4. employees
5. LIMIT
6. 10

PRQL

1. from orders
2. sort {-value, created_at}
3. take 101..110

SQL

1. SELECT
2. *
3. FROM
4. orders
5. ORDER BY
6. value DESC,
7. created_at
8. LIMIT
9. 10 OFFSET 100