概述
LIMIT
语句可限制工作表中保留的最大记录数。必须在LIMIT
语句中指定一个非负整数。
<limit statement> ::= "LIMIT" <non-negative integer>
示例图

CREATE GRAPH myGraph {
NODE Paper ({title string, score uint32, author string}),
EDGE Cites ()-[]->()
} PARTITION BY HASH(Crc32) SHARDS [1]
INSERT (p1:Paper {_id:'P1', title:'Efficient Graph Search', score:6, author:'Alex'}),
(p2:Paper {_id:'P2', title:'Optimizing Queries', score:9, author:'Alex'}),
(p3:Paper {_id:'P3', title:'Path Patterns', score:7, author:'Zack'}),
(p1)-[:Cites]->(p2),
(p2)-[:Cites]->(p3)
限制返回记录数
MATCH (n:Paper)
RETURN n.title LIMIT 2
结果:
n.title |
---|
Efficient Graph Search |
Optimizing Queries |
限制传递记录数
MATCH (n:Paper) LIMIT 1
MATCH p = (n)->()
RETURN p
结果:p

限制排序后的记录数
MATCH (n:Paper)
ORDER BY n.title DESC
LIMIT 1
RETURN n.title
结果:
n.title |
---|
Path Patterns |