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 Route table
PARTITION BY
Summary

Instruction

Alright, let's move on. Table number two is called Route.

Exercise

Select all the information from the table Route.

A route is a railroad connection between points A and B.

Each route has its own Id, a Name, a FromCity, a ToCity, and a Distance (in kilometers).

For simplicity, we'll assume that there are only intercity routes, i.e. there are no stations between the FromCity and the ToCity.