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[…]