Skip to main content

limit()

Limits the result with the specified count.

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

Examples​

With select()​

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

With embedded resources​

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