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 GroceryStore table
CTEs with data modifying statements
Summary

Instruction

First, let's see the database. In this part, you will work with data related to grocery stores: their products, orders, and customers.

Let's look at the tables we're going to work with. The first table is the GroceryStore table. It gives basic identifying information for grocery stores.

Exercise

Select all the information from the GroceryStore table. This table consists of the columns:

  • Id – the identifier of the grocery store,
  • Name – the name of the grocery store,
  • City – the name of the city in which that grocery store is located.