概述
SKIP语句可从当前工作表的开头丢弃指定数量的记录。必须在SKIP中指定一个非负整数。
OFFSET可作为SKIP的同义词使用。
<skip statement> ::= "SKIP" <non-negative integer>
示例图集
以下示例根据该图集运行：
在空图集中运行以下语句创建示例图集：
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 {weight:2}]->(p2),
(p2)-[:Cites {weight:1}]->(p3)
跳过N条记录
MATCH (n:Paper)
RETURN n.title SKIP 1
结果：
| n.title |
|---|
| Efficient Graph Search |
| Path Patterns |
跳过N条有序记录
MATCH (n:Paper)
ORDER BY n.score
SKIP 1
MATCH p = (n)->()
RETURN p
结果：
| p |
|---|
| (:Paper {_id: "P2", score: 9, title: "Optimizing Queries", author: "Alex"})-[:Cites {weight: 1}]->(:Paper {_id: "P3", score: 7, title: "Path Patterns", author: "Zack"}) |