SKIP discards the first N rows of data in the data stream.
Syntax: SKIP <number>
Input:
- <number> The number of rows to be discarded
find().nodes([1, 5]) as nodes
n(nodes).e()[:2].n() as path
skip 2
return path
In the UQL above, SKIP discards the first two rows of paths resulted from template query.
Common Usage
Example: Find all cards that transferred money to Card CA029, return them in a descending order of their balances with the first 4 data discarded, in another word, without returning the 3 cards that have the highest balances from all cards
n({_id == "CA029"}).le({@transfer}).n({@card} as n)
return n{*} skip 3
order by n.balance DESC