Neo4j教程

Neo4j Order By

在Neo4j中,ORDER BY子句用于按顺序排列结果数据。
语法:
MATCH (n)  
return n.property1, n.property2 . . . . . . . .  
ORDER BY n.property 
让我们在Neo4j数据库中创建一些节点。
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"})
输出:
Neo4j Orders by子句1
您可以看到6节点已创建。
MATCH (n)  
return n.name, n.Marks 
ORDER BY n.Marks 
输出:
Neo4j Orders by子句2

通过多个属性订购节点

ORDER BY子句用于根据多个属性排列节点。
语法:
MATCH (n) 
return n 
ORDER BY n.property_1, n.property_2 
示例:
MATCH (n) 
return n.name, n.Marks, n.country 
ORDER BY n.name, n.Marks
输出:
Neo4j Orders by子句3

降序排列的节点

语法:
MATCH (n) 
return n 
ORDER BY n.property DESC 
现在按降序排列数据库的节点:
MATCH (n)  
return n.name, n.Marks 
ORDER BY n.Marks DESC
输出:
Neo4j Orders by子句4
昵称: 邮箱:
Copyright © 2022 立地货 All Rights Reserved.
备案号:京ICP备14037608号-4