Neo4j Order By Clause

In Neo4j, The ORDER BY Clause is used to arrange the result data in order.

Syntax:

MATCH (n)  
RETURN n.property1, n.property2 . . . . . . . .  
ORDER BY n.property 

Let's create some nodes in the Neo4j database.

CREATE(a:student{name:"Ajeet", YOB: 1989, Marks:80, country: "India"})
CREATE(b:student{name:"Mayur", YOB: 1990, Marks:70, country: "India"})
CREATE(c:student{name:"Chetna", YOB: 1991, Marks:60, country: "India"})
CREATE(d:student{name:"Rahul", YOB: 1992, Marks:78, country: "India"})
CREATE(e:student{name:"Mohan", YOB: 1993, Marks:58, country: "India"})
CREATE(f:student{name:"Swati", YOB: 1994, Marks:85, country: "India"})

Output:

You can see that 6 nodes are created.

MATCH (n)  
RETURN n.name, n.Marks 
ORDER BY n.Marks 

Output:

Order Nodes by Multiple Properties

ORDER BY clause is used to arrange the nodes based on multiple properties.

Syntax:

MATCH (n) 
RETURN n 
ORDER BY n.property_1, n.property_2 

Example:

MATCH (n) 
RETURN n.name, n.Marks, n.country 
ORDER BY n.name, n.Marks

Output:

Order Nodes in Descending Order

Syntax:

MATCH (n) 
RETURN n 
ORDER BY n.property DESC 

Now arrange the nodes of the database in descending order:

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

Output:

Next TopicNeo4j Limit Clause

← prev next →

Latest Courses

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

Contact info

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

[email protected].

Python

AI, ML and Data Science

Java

B.Tech and MCA

Web Technology

Software Testing

Technical Interview

Java Interview

Web Interview

Database Interview

Company Interviews

Neo4j Tutorial

GraphDB

Neo4j CQL

General Clauses

Read Clauses

Write Clauses

Functions

Interview Questions

Neo4j Order By Clause

Order Nodes by Multiple Properties

Order Nodes in Descending Order

Latest Courses

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler