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