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
2. The Store Table
Quick Refresher
PARTITION BY ORDER BY with Ranking
PARTITION BY ORDER BY with Window Frames
Using PARTITION BY ORDER BY with Analytical Functions
Summary and Review

Instruction

Ok, first things first. Today, we're going to work with a retail store. Let's get to know the tables.

Exercise

Select all the information from the Store table.

Each store has its own Id, Country and City. There is only one store per city in our table to make things a bit easier. Apart from that, you can see when the store was opened (OpeningData) and what Rating it has (1-5), based on customers' opinions.