Window Functions
conditional_change_event
Returns the event window number of this row in the window based on whether the argument expression on the current row differs from that on the previous row Supported Signatures
function conditional_change_event($1) returns decimal(38, 0)
conditional_true_event
Returns the event window number of this row in the window based on the result of the boolean argument expression Supported Signatures
function conditional_true_event(boolean) returns decimal(38, 0)
function conditional_true_event(decimal(38, 0)) returns decimal(38, 0)
cume_dist
Returns the cumulative distribution of a row in the window Supported Signatures
function cume_dist() returns double
dense_rank
Returns the dense rank of a row in the window Supported Signatures
function dense_rank() returns decimal(38, 0)
first_value
Returns the first value of a column Supported Signatures
function first_value($1) returns $1
lag
Returns the value of an expression at the specified offset row Supported Signatures
function lag($1) returns $1
function lag($1, decimal(38, 0)) returns $1
function lag($1, decimal(38, 0), $1) returns $1
last_value
Returns the last value of a column Supported Signatures
function last_value($1) returns $1
lead
Returns the value of an expression at the specified offset row Supported Signatures
function lead($1) returns $1
function lead($1, decimal(38, 0)) returns $1
function lead($1, decimal(38, 0), $1) returns $1
nth_value
Returns the first value of a column Supported Signatures
function nth_value($1, decimal(38, 0)) returns $1
ntile
Number of groups (ntiles) per window Supported Signatures
function ntile(decimal(38, 0)) returns decimal(38, 0)
percent_rank
Returns the percent rank of a row in the window Supported Signatures
function percent_rank() returns double
rank
Returns the rank of a row in the window Supported Signatures
function rank() returns decimal(38, 0)
ratio_to_report
Returns a cumulative ratio_to_report of a column Supported Signatures
function ratio_to_report(decimal(38, 0)) returns decimal(38, 0)
function ratio_to_report(decimal(38, 0), decimal(38, 0)) returns decimal(38, 0)
function ratio_to_report(double) returns double
function ratio_to_report(double, decimal(38, 0)) returns double
row_number
Returns the position of this row in the window Supported Signatures
function row_number() returns decimal(38, 0)