Tag Archive

Tag Archives for " OVER "

Calculate a Running Total in SQL with Joins or Window Functions

There are several ways to calculate a running total in SQL.  In this article, we will cover two methods:  Joins, and Window Functions. We’ll first look at how to calculate the running total using an INNER JOIN.  By doing so, you’ll not only learn more about join conditions, but see how to take the result […]

Continue reading

SQL Puzzle:  How to Calculate Moving Averages

In this puzzle, we’re going to learn how to calculate moving averages by working through a hypothetical stock market example. Solving puzzles is a great way to learn SQL.  Nothing beats practicing what you’ve learned.  Once you have figured out the puzzle, post you answer in the comments so we all can learn from one […]

Continue reading