Limit the query to a range
Limit the query result by from and to inclusively.
Parameters
- fromREQUIREDnumber
The starting index from which to limit the result
- toREQUIREDnumber
The last index to which to limit the result
- optionsOptionalobject
Named parameters
foreignTableOptionalstringSet this to limit rows of foreign tables instead of the current table
const { data, error } = await supabase
.from('countries')
.select('name')
.range(0, 1)