> ## Documentation Index
> Fetch the complete documentation index at: https://docs.falkordb.com/llms.txt
> Use this file to discover all available pages before exploring further.

> ## Agent Instructions
> FalkorDB is a graph database that speaks the Redis protocol. Queries are issued as OpenCypher through the GRAPH.QUERY and GRAPH.RO_QUERY commands, not over Bolt or a SQL connection.
> FalkorDB implements a subset of OpenCypher with proprietary extensions. Do not assume Neo4j-only syntax or procedures are available — check /cypher/cypher-support and /cypher/known-limitations before using a clause.
> FalkorDB is the successor to RedisGraph, but they are separate products. Do not present RedisGraph commands, versions, or limitations as current FalkorDB behavior.
> Use the official clients listed in /getting-started/clients rather than generic Redis or Neo4j drivers, and prefer the language the user is already working in.
> Configuration parameters are set with GRAPH.CONFIG SET or at startup; cite the exact parameter name from /getting-started/configuration rather than inventing one.
> This site covers four products: FalkorDB (core), FalkorDB Cloud, FalkorDB Enterprise, and the GraphRAG SDK. Name which one an answer applies to, since setup and operations differ.

# LIMIT

> Can use the limit clause to limit the number of records returned by a query

Although not mandatory, you can use the limit clause
to limit the number of records returned by a query:

```sql theme={null}
LIMIT <max records to return>
```

If not specified, there's no limit to the number of records returned by a query.

## Frequently Asked Questions

<AccordionGroup>
  <Accordion title="Is there a default limit on query results?">
    No. If you do not specify a LIMIT clause, FalkorDB returns all matching records with no upper bound.
  </Accordion>

  <Accordion title="Does LIMIT improve query performance?">
    LIMIT can reduce the amount of data transferred to the client, but due to a known limitation, it does not currently short-circuit eager operations like CREATE, SET, or DELETE. The full operation executes before LIMIT is applied.
  </Accordion>

  <Accordion title="Can I use LIMIT without ORDER BY?">
    Yes, but the subset of results returned will be non-deterministic. Combine LIMIT with ORDER BY for predictable, repeatable results.
  </Accordion>
</AccordionGroup>