Finding the last month's values

The "Median" Function

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.