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');