Kotlin: Limit the number of rows returned

Limit the query result by count.

Parameters

• count

  (Required)

  The number of rows to limit the result to.

• referencedTable

  (Optional)

  The foreign table to limit by.

Examples

With `select()`

supabase.from("countries").select \{
    limit(count = 1)
\}

On a foreign table

val columns = Columns.raw("""
    name,
    cities (
        name
    )
""")
supabase.from("countries").select(
    columns = columns
) \{
    limit(count = 1, referencedTable = "cities")
\}