Window Functions vs Aggregate Functions in SQL: A Beginner-Friendly Guide

If you have written SQL for more than a week, you have used SUM(), AVG() or COUNT(). They are the bread and butter of reporting. Then one day someone says, "Just use a window function for that", and suddenly you are staring at a query with OVER (PARTITION BY ...) in it and wondering what you missed. This article is for you if you are just starting... Weiterlesen