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

Common Functions in MS SQL Server

Quiz
2. The Person table

Instruction

Nice! Let's analyze the other table.

Exercise

Select all information from the Person table. Each person has:

  • Id,
  • BranchId,
  • FirstName,
  • MiddleName,
  • LastName,
  • RegistrationDate,
  • Iq,
  • Weight in kilograms,
  • Height in centimeters.

The BranchId is the ID of the branch that person belongs to.

Note: each person can only belong to one branch.