Window functions (part3) – new functions

Adriano posted in his blog about new Window functions introduced in Firebird 3.

[…]Now, new window-only functions has been introduced. I’ll separate them in two groups: ranking and navigational. Both set of functions can be used with/without partition/ordering, but them does not make much sense without ordering.[…]

Read the full post here.

Window Functions in Firebird 3

Adriano has published in his blog some information about the implementation of the OVER function in Firebird 3. Really cool.

By the SQL specification, window functions are a kind of aggregation, but which does not “filter” the result set of a query. The aggregated data is mixed with the query result set. That sort of functions are used with the OVER clause. Users of Oracle also knows window functions as analytical functions[…]

1 30 31 32 33 34 78