LIMIT

Overview

The LIMIT statement restricts the maximum number of records to be retained in the intermediate result or output table. A non-negative integer must be specified in the LIMIT statement.

Syntax
<limit statement> ::= "LIMIT" <non-negative integer>

Example Graph

Create the graphInsert data to the graph
CREATE GRAPH myGraph { 
  NODE Paper ({title string, score uint32, author string}),
  EDGE Cites ()-[{}]->()
} PARTITION BY HASH(Crc32) SHARDS [1]

Limiting Records Returned

GQL
MATCH (n:Paper)
RETURN n.title LIMIT 2

Result:

Limiting Records Passed Forward

GQL
MATCH (n:Paper) LIMIT 1
MATCH p = (n)->()
RETURN p

Result: p

Limiting Ordered Records

GQL
MATCH (n:Paper)
ORDER BY n.title DESC 
LIMIT 1
RETURN n.title

Result: