limit()

Limits the result with the specified count.

• JavaScript
• Python

const { data, error } = await supabase

.from('cities')

.select('name, country_id')

.limit(1)

Parameters

• countrequirednumber

  The maximum no. of rows to limit to.

• __namedParametersrequiredobject

  No description provided.

  Properties

  • foreignTablerequired|

    The foreign table to use (for foreign columns).

Examples

With select()

• JavaScript
• Python

const { data, error } = await supabase

.from('cities')

.select('name, country_id')

.limit(1)

With embedded resources

• JavaScript
• Python

const { data, error } = await supabase

.from('cities')

.select('name, cities(name)')

.eq('name', 'United States')

.limit(1, 'cities')