Window functions
PREFIX win: <http://w3id.org/tripletrail/window#>
SQL window functions over the rows of a group graph pattern, in SERVICE <http://w3id.org/tripletrail/window>: rankings, running totals, lag and lead, partitioned and ordered as in SQL's OVER (PARTITION BY … ORDER BY …).
Turtle: window.ttl. Reference: Function matrix.
| Term | Kind | Description |
|---|---|---|
win:partitionBy | Parameter | |
win:orderBy | Parameter | |
win:orderByDesc | Parameter | |
win:rows | Parameter | |
win:rowNumber | Function | |
win:rank | Function | |
win:denseRank | Function | |
win:percentRank | Function | |
win:cumeDist | Function | |
win:ntile | Function | Buckets 1 to n, the first ones one row larger when the rows do not divide evenly. |
win:firstValue | Function | |
win:lastValue | Function | |
win:sum | Function | |
win:avg | Function | |
win:min | Function | |
win:max | Function | |
win:count | Function | |
win:lag | Function | The value offset rows (1 by default) before or after in the partition, else the default (unbound by default). |
win:lead | Function | The value offset rows (1 by default) before or after in the partition, else the default (unbound by default). |