with

可以在结果传递到后面之前对结果进行操作

通常是order by 和limit

 

 

create
(anders:Person{Name:"Anders"}),
(ceasar:Person{Name:"Ceasar"}),
(bossman:Person{Name:"Bossman"}),
(emit:Person{Name:"Emit"}),
(david:Person{Name:"David"}),

(anders)-[:BLOCKS]->(ceasar),
(anders)-[:KNOWS]->(bossman),
(ceasar)-[:KNOWS]->(emit),
(bossman)-[:KNOWS]->(emit),
(anders)-[:KNOWS]->(david),
(bossman)-[:BLOCKS]->(david)

 

1.过滤聚合函数的结果
//不包含自身
match(david{Name:"David"})--(otherpeople)-->()with otherpeople,count(*)as foaf where foaf>1 return otherpeople
2.在collect前对结果排序
match(n)with n order by n.Name desc limit 3 return collect(n.Name)
3.限制路径搜索的分支
//包含自身
MATCH(n{Name:"Anders"})--(m)with m order by m.Name desc limit 1 match(m)--(o)return m, o