Flutter: Limit the number of rows returned

Limits the result with the specified count.

Parameters

• count

  (Required)

  The maximum number of rows to return.

• referencedTable

  (Optional)

  Set this to limit rows of referenced tables instead of the parent table.

Examples

With select()

final data = await supabase .from('instruments') .select('name') .limit(1); 

On a referenced table

final data = await supabase .from('orchestral_sections') .select(''' name, instruments ( name ) ''') .limit(1, referencedTable: 'instruments');