JavaScript: Limit the query to a range

Limit the query result by starting at an offset from and ending at the offset to. Only records within this range are returned. This respects the query order and if there is no order clause the range could behave unexpectedly. The from and to values are 0-based and inclusive: range(1, 3) will include the second, third and fourth rows of the query.

Parameters

• from

  (Required)

  The starting index from which to limit the result

• to

  (Required)

  The last index to which to limit the result

• options

  (Required)

  Named parameters

Examples

With `select()`

const { data, error } = await supabase
  .from('countries')
  .select('name')
  .range(0, 1)