Flutter: Limit the number of rows returned

Limits the result with the specified count.

Examples

With `select()`

final data = await supabase
  .from('cities')
  .select('name, country_id')
  .limit(1);

With embedded resources

final data = await supabase
  .from('countries')
  .select('name, cities(name)')
  .eq('name', 'United States')
  .limit(1,  foreignTable: 'cities' );