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('countries')
  .select('name')
  .limit(1)

On a referenced table

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