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)

🔗 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
function first_value($1, integer) 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
function last_value($1, integer) 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