Sometimes, within an RPG program or a complex SQL query, there is a need to include a row counter, a running total, find a previous record, or create a ranking based on a specific value. This problem ...

ROUND(AVG(Salary) OVER (PARTITION BY Department), 2) AS DeptAvgSalary, ROUND(Salary - AVG(Salary) OVER (PARTITION BY Department), 2) AS DiffFromAvg ...

Window functions changed how I think about SQL problems ,not just "can I get this answer" but "can I get it without destroying the grain of my data." That's the shift. The moment you stop reaching for ...

--windows functions are really powerful and are somewhat like a group by - except they don't roll everything up into 1 row when grouping. --windows functions allow us to look at a partition or a group ...