Limit the number of rows returned

Limits the result with the specified count.

count

REQUIRED

number

The maximum no. of rows to limit to.

__namedParameters

Optional

object

foreignTable

REQUIRED

undefined | string

The foreign table to use (for foreign columns).


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