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
4. The Customer table
CTEs with data modifying statements
Summary

Instruction

Now, the next table is the Customer table. It contains customer details like their name, age, city, and shopper discount amount.

Exercise

Select all information from the Customer table.

This table has the following columns:

  • Id – the identifier of the customer,
  • FirstName – the first name of the customer,
  • LastName – the last name of the customer,
  • City – the name of the city in which that customer lives,
  • Age – the age of the customer,
  • Discount – the customer's discount.