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