SQL Window Functions to your rescue

Frode Borlaug

Lightning talk - in Norwegian

SQL Window Functions are a little-known feature of Standard SQL, but very powerful.

A SQL Windows Function do calculations across a set of rows (window), these rows are somehow related to the current row.

Compared to classical aggregate functions in SQL, aggregate as Window Functions do not cause rows to be grouped into one output row in the result but return all the rows in the result.

The SQL Window Functions can be of statistical/analytical, ranking or aggregate type.

Through this talk I will give developers and data analysts a little glimpse into this world. I will start with a little introduction, and then a few examples.