Format, Parameters
SKIP discards the first N rows of data in the data stream.
Syntax:
- Format: skip
<number> - Parameters: see table below
- Affected columns: data columns produced by previous UQL statement and all their homologous columns
| Name | Category | Specification | Description |
|---|---|---|---|
<number> |
int32 | / | The rows to be discarded |
Analysis
find().nodes([1, 5]) as nodes
n(nodes).e()[:2].n() as path
skip 2
return path
In the UQL example above, SKIP discards the first two rows of paths resulting 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