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