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
Selecting n-th row
Summary

Instruction

Welcome! In this part, we'll teach you how to use window functions in SQL Server for something very useful – creating rankings. Which product is the bestseller? Which service ranks third? Which Internet Service Provider has the worst worst feedback? You'll learn how to answer questions like these in this part.

Today, we're working on some imaginary mobile game development studio. Let's see what they've sent us.

Exercise

Select all the information in the Game table.

Each game has an Id, a Name, a Genre, an EditorRating, a Size (in MB), and a specific Platform it runs on. There are also two date-related columns: ReleaseDate specifies when the game was released, and UpdateDate stores when the game was last updated.