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

Recursive Queries in MS SQL Server

Introduction
2. The Salesman table
Nested CTEs
Summary

Instruction

First things first, though. Let's get to know today's data model. We're going to analyze the data of a company that sells small items on a door-to-door basis.

Exercise

Select all the information from the Salesman table.

Each salesperson has a unique ID, a first and last name, and an ID for the city where he or she operates.