<F> WindowJDFrame<T> |
WindowJDFrame.overAvgS(SetFunction<T,BigDecimal> setFunction,
java.util.function.Function<T,F> field) |
avg window function
calculate the avg value within the window range
|
WindowJDFrame<T> |
WindowJDFrame.overCountS(SetFunction<T,Integer> setFunction) |
count window function
calculate the count within the window range
|
WindowJDFrame<T> |
WindowJDFrame.overCumeDistS(SetFunction<T,BigDecimal> setFunction) |
Cume Dist window function
set the function result to the setFunction
|
WindowJDFrame<T> |
WindowJDFrame.overDenseRankS(SetFunction<T,Integer> setFunction) |
dense rank window function
set the function result to the setFunction
|
<F> WindowJDFrame<T> |
WindowJDFrame.overFirstValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field) |
FirstValue window function
get the first row within the window range
|
<F> WindowJDFrame<T> |
WindowJDFrame.overLagS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field,
int n) |
Lag window function
get the value of the first n rows of the current row
|
<F> WindowJDFrame<T> |
WindowJDFrame.overLastValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field) |
LastValue window function
get the last row within the window range
|
<F> WindowJDFrame<T> |
WindowJDFrame.overLeadS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field,
int n) |
lead window function
get the value of the last n rows of the current row
|
<F> WindowJDFrame<T> |
WindowJDFrameImpl.overLeadS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field,
int n) |
|
<F extends Comparable<? super F>>
WindowJDFrame<T> |
WindowJDFrame.overMaxValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field) |
max window function
calculate the max value within the window range
|
<F extends Comparable<? super F>>
WindowJDFrame<T> |
WindowJDFrame.overMinValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field) |
min window function
calculate the min value within the window range
|
<F> WindowJDFrame<T> |
WindowJDFrame.overNthValueS(SetFunction<T,F> setFunction,
java.util.function.Function<T,F> field,
int n) |
NthValue window function
get the Nth row within the window range
|
WindowJDFrame<T> |
WindowJDFrame.overNtileS(SetFunction<T,Integer> setFunction,
int n) |
Ntile window function
assign bucket numbers evenly to windows, starting from 1
|
WindowJDFrame<T> |
WindowJDFrame.overPercentRankS(SetFunction<T,BigDecimal> setFunction) |
Percent rank window function
set the function result to the setFunction
|
WindowJDFrame<T> |
WindowJDFrame.overRankS(SetFunction<T,Integer> setFunction) |
rank window function
set the function result to the setFunction
|
WindowJDFrame<T> |
WindowJDFrame.overRowNumberS(SetFunction<T,Integer> setFunction) |
rowNumber window function
set the function result to the setFunction
|
<F> WindowJDFrame<T> |
WindowJDFrame.overSumS(SetFunction<T,BigDecimal> setFunction,
java.util.function.Function<T,F> field) |
sum window function
calculate the sum value within the window range
|
WindowJDFrame<T> |
JDFrame.window() |
open a empty window
|
WindowJDFrame<T> |
JDFrame.window(Window<T> window) |
open a window
|
WindowJDFrame<T> |
JDFrameImpl.window() |
|
WindowJDFrame<T> |
JDFrameImpl.window(Window<T> window) |
================= Window ============================================
|