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 →

Please Share

Learn Latest Tutorials

Angular 7

D. Science

ReactJS

Software E.

Electrical M.

Preparation

Aptitude

Reasoning

Verbal A.

Interview

Company

Trending Technologies

AWS

Selenium

IoT

Cloud

Hadoop

B.Tech / MCA

DBMS

DAA

C. Network

Compiler D.

COA

D. Math.

E. Hacking

C. Graphics

Web Tech.

Cyber Sec.

Automata

C++

Java

.Net

Python

Programs

Control S.

Javatpoint Services

JavaTpoint offers too many high quality services. Mail us on hr@javatpoint.com, to get more information about given services.

Website Designing
Website Development
Java Development
PHP Development
WordPress
Graphic Designing
Logo
Digital Marketing
On Page and Off Page SEO
PPC
Content Development
Corporate Training
Classroom and Online Training
Data Entry

Training For College Campus

JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at hr@javatpoint.com.
Duration: 1 week to 2 week

^{Like/Subscribe us for latest updates or newsletter}