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("characters").select {
    limit(count = 1)
}

On a foreign table

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