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)
🔗 Official Documentation
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)
🔗 Official Documentation
cume_dist
Returns the cumulative distribution of a row in the window
Supported Signatures
function cume_dist() returns double
🔗 Official Documentation
dense_rank
Returns the dense rank of a row in the window
Supported Signatures
function dense_rank() returns decimal(38, 0)
🔗 Official Documentation
first_value
Returns the first value of a column
Supported Signatures
function first_value($1) returns $1
🔗 Official Documentation
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
🔗 Official Documentation
last_value
Returns the last value of a column
Supported Signatures
function last_value($1) returns $1
🔗 Official Documentation
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
🔗 Official Documentation
nth_value
Returns the first value of a column
Supported Signatures
function nth_value($1, decimal(38, 0)) returns $1
🔗 Official Documentation
ntile
Number of groups (ntiles) per window
Supported Signatures
function ntile(decimal(38, 0)) returns decimal(38, 0)
🔗 Official Documentation
percent_rank
Returns the percent rank of a row in the window
Supported Signatures
function percent_rank() returns double
🔗 Official Documentation
rank
Returns the rank of a row in the window
Supported Signatures
function rank() returns decimal(38, 0)
🔗 Official Documentation
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
🔗 Official Documentation
row_number
Returns the position of this row in the window
Supported Signatures
function row_number() returns decimal(38, 0)
🔗 Official Documentation
