Calculate the difference between each record and the previous or next one.
According to the standard, we should use be using FETCH.
Assigning each record to a specific segment based on the value of one or more columns.
For those who knew SQL, but kinda forgot it.
Assigning a rank to each row based on the value of one or more columns.
Moving averages, cumulative totals and other sliding aggregates.
Comparing individual values with totals and averages.
Turn static SQL code in your articles into executable examples.
Comparing records with neighbors and boundaries.
Making ratings and dividing data into partitions.
To build great analytical reports without Excel.
A clear and visual introduction to window functions in SQL.
Regexes, math, file IO and over 100 other functions.
Strict tables, any type and a new pragma.
CC-licensed design guide for presentations, reports, and dashboards.