Neo4j LIMIT Clause

The Neo4j LIMIT clause is used to limit the number of rows in the output.

Syntax:

MATCH (n) 
RETURN n 
ORDER BY n.name 
LIMIT i

Here, I may be 1,2, 3? etc.

Example:

Let's fetch records from database where LIMIT is set to 3.

MATCH (n)  
RETURN n.name, n.Marks 
ORDER BY n.Marks DESC 
LIMIT 3 

Output:

LIMIT with Expression

The LIMIT clause can also be used with expressions.

Example:

Use the "rand" expression with LIMIT clause.

MATCH (n) 
RETURN n.name, n.Marks 
ORDER BY n.Marks DESC 
LIMIT toInt(3 * rand())+ 1 

Output:

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India