Chad Callihan shows off one of the best window functions:
The LAG function in SQL Server allows you to work with a row of data as well as the previous row of data in a data set. When would that ever be useful? If you’re a sports fan, you’re familiar with this concept whether you realize it or not. Let’s look at an example.
LAG() is outstanding for business reports, such as if you want three-month trailing data.