Overview
The SKIP statement allows you to discard a specified number of records from the start of the working table. A non-negative integer must be specified in SKIP.
OFFSETcan be used as a synonym toSKIP.
<skip statement> ::= "SKIP" <non-negative integer>
Example Graph
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)
Skipping N Records
MATCH (n:Paper)
RETURN n.title SKIP 1
Result:
| n.title |
|---|
| Efficient Graph Search |
| Path Patterns |
Skipping N Ordered Records
MATCH (n:Paper)
ORDER BY n.score
SKIP 1
MATCH p = (n)->()
RETURN p
Result: p
