Window Functions E-book

Learn everything you need to know about Window Functions in Microsoft SQL Server!

Window functions are considered an advanced T-SQL querying tool in Microsoft SQL Server. In this short e-book, we discuss all the window functions available to us and provide examples of how to write them.

We discuss the following window functions in this ebook:

• Chapter 1: What is a window function?
• Chapter 2: The parts to a window query
• Chapter 3: Aggregate window functions
  • SUM
  • COUNT
  • MIN
  • MAX
  • AVG
• Chapter 4: Ranking window functions
  • ROW_NUMBER
  • RANK
  • DENSE_RANK
  • NTILE
• Chapter 5: Offset window functions
  • FIRST_VALUE
  • LAST_VALUE
  • LAG
  • LEAD

I understand how complex some of these advanced querying tools can be. This book starts with the absolute basics you need to know, then builds upon that with simple examples and analogies to help you understand the different parts to a window function and how they work.

After reading this book, I'm confident you'll consider window functions to be fairly simple after all!