Tümünü genişlet/daralt

Window functions

Window functions perform calculations using values from multiple rows to produce a value for each row separately. Window functions can only be calculated once the entire table is read.

You can use window functions to perform operations such as:

• Comparing an individual number value in a row with the average, maximum, or minimum within the column.

• Calculating the rank of an individual value, either within the column or within the entire table.

Window functions do not change the number of records in the table but can perform similar tasks as aggregation functions or relational functions and range functions.

Her bir fonksiyonun kısa açıklamasını ve söz dizimini görmek için her bir fonksiyonun açılan menüsünü kullanın. Daha ayrıntılı bilgiler için söz dizimi açıklamasında fonksiyon adına tıklayın.

Window

The Window function performs calculations from multiple rows, producing a value for each row separately.

window(main_expr, [partition1, partition2, ...], [sort_type, [sort_expr],[filter_expr], [start_expr, end_expr]])

WRank

The WRank function performs ranking calculations inside Window.

wrank([mode[, fmt]])