LIMIT
LIMITconstrains the number of returned rows.
1. Introduction
LIMIT accepts any expression that evaluates to a positive integer — however the expression cannot refer to nodes or relationships.
2. Return a limited subset of the rows
To return a limited subset of the rows, use this syntax:
Query
MATCH (n)
RETURN n.name
ORDER BY n.name
LIMIT 3Limit to 3 rows by the example query.
| n.name |
|---|
|
|
|
Rows: 3 |
3. Using an expression with LIMIT to return a subset of the rows
Limit accepts any expression that evaluates to a positive integer as long as it is not referring to any external variables:
Query
MATCH (n)
RETURN n.name
ORDER BY n.name
LIMIT 1 + toInteger(3 * rand())Limit 1 row plus randomly 0, 1, or 2. So randomly limit to 1, 2, or 3 rows.
| n.name |
|---|
|
|
Rows: 2 |
Was this page helpful?