Window functions are your friends
Database Administration & Development
What does SUM(Salary) OVER (ORDER BY EmployeeID RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING) do exactly? Did you know that you can delete all duplicates in a table with just one query?
Window functions are great! They open a whole new world of elegant data analysis. Their only problem is that they seem complicated at first glance. In this session we will get OVER() them and see how can we use them together with aggregation, analytic and ranking functions. After this session creating queries with things like running totals will be a piece of cake!