JavaScript: Limit the query to a range

Limit the query result by starting at an offset (from) and ending at the offset (from + 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)