JavaScript: Limit the number of rows returned

Limit the query result by count.

Parameters

• count

  (Required)

  The maximum number of rows to return

• options

  (Required)

  Named parameters

Examples

With `select()`

const { data, error } = await supabase
  .from('characters')
  .select('name')
  .limit(1)

On a referenced table

const { data, error } = await supabase
  .from('orchestral_sections')
  .select(`
    name,
    instruments (
      name
    )
  `)
  .limit(1, { referencedTable: 'instruments' })