Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

Window Functions in MS SQL Server

Introduction
1. Introduction
LEAD() and LAG()
FIRST_VALUE(), LAST_VALUE()
Summary

Instruction

Greetings! In this part we're going to introduce you to a few popular analytic functions that are often used with window functions. Thanks to these functions, you'll be able to write queries that are useful for making business decisions. Are you ready?

Exercise

Click Next exercise to continue.