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