Order the results
Orders the result with the specified column.
Parameters
column
REQUIRED
StringThe column to order by.
ascending
Optional
boolWhether to order in ascending order. Default is false
.
nullsFirst
Optional
boolWhether to order nulls first. Default is false
.
referencedTable
Optional
StringSpecify the referenced table when ordering by a column in an embedded resource.
final data = await supabase
.from('cities')
.select('name, country_id')
.order('id', ascending: true);