Vocabularies

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.

TermKindDescription
win:partitionByParameter
win:orderByParameter
win:orderByDescParameter
win:rowsParameter
win:rowNumberFunction
win:rankFunction
win:denseRankFunction
win:percentRankFunction
win:cumeDistFunction
win:ntileFunctionBuckets 1 to n, the first ones one row larger when the rows do not divide evenly.
win:firstValueFunction
win:lastValueFunction
win:sumFunction
win:avgFunction
win:minFunction
win:maxFunction
win:countFunction
win:lagFunctionThe value offset rows (1 by default) before or after in the partition, else the default (unbound by default).
win:leadFunctionThe value offset rows (1 by default) before or after in the partition, else the default (unbound by default).