SKIP

Overview

The SKIP statement allows you to discard a specified number of records from the start of the intermediate result or output table. A non-negative integer must be specified in SKIP.

OFFSET can be used as a synonym to SKIP.

<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:

Skipping N Ordered Records

MATCH (n:Paper)
ORDER BY n.score 
SKIP 1
MATCH p = (n)->()
RETURN p

Result: p