LIMIT
LIMIT
constrains the number of rows in the output.
1. Introduction
LIMIT
accepts any expression that evaluates to a positive integer — however the expression cannot refer to nodes or relationships.
2. Return a subset of the rows
To return a subset of the result, starting from the top, use this syntax:
Query
MATCH (n)
RETURN n.name
ORDER BY n.name
LIMIT 3
The top three items are returned by the example query.
n.name |
---|
|
|
|
3 rows |
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 toInteger(3 * rand())+ 1
Returns one to three top items.
n.name |
---|
|
1 row |
Was this page helpful?