LIMIT

1. Introduction

LIMIT accepts any expression that evaluates to a positive integer — however the expression cannot refer to nodes or relationships.

Diagram

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.

Table 1. Result
n.name

"A"

"B"

"C"

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.

Table 2. Result
n.name

"A"

1 row