Calculate the Days Between Orders

Using TOP with ROW_NUMBER

Calculate Moving Averages using T-SQL in SQL Server

Introduction In Financial Data, analyzing the Moving Average (MA) is a very common practice. The direction of the moving average conveys important information about prices, whether that average is simple or exponential. A rising moving average shows that prices are generally increasing. A falling moving average indicates that prices, on average, are falling. This article […]

Calculate the Days Between First and Last Orders

An Intro to SQL Window Functions

Learn about some window function basics in T-SQL

What’s the Difference Between PERCENT_RANK and CUME_DIST?

Learn a bit about the different results you get from the PERCENT_RANK and CUME_DIST aggregate functions.

Christmas 2018 Trivia

Introduction to T-SQL Window Functions

T-SQL window functions were introduced in 2005 with more functionality added in 2012. Many database professionals are not aware of these useful functions. In this article, Kathi Kellenberger provides a quick overview of just what a window function is as well as examples of each type of function.

The Lonely Count

Window Functions in SQL

SQL's windowing functions are surprisingly versatile, and allow us to cut out all those self-joins and explicit cursors. Joe Celko explains how they are used, and shows a few tricks such as calculating deltas in a time series, and filling in gaps.