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

SQL Basics in MS SQL Server

Returning all data from a table
2. Read the result
Select some columns
Filtering rows
Logic
Text patterns
To be or NULL to be
A bit of mathematics
Let's practice

Instruction

As you can see, the Car table has six columns:

  1. Vin (short for vehicle identification number)
  2. Brand
  3. Model
  4. Price
  5. ProductionYear
  6. FirstOwner (a flag denoting whether the current owner of a given car is also the first owner)

The names of the columns appear at the top of the result table.

There are eight cars in our table: two Fords, one Toyota, three Volkswagens, one Fiat, and one Opel. You can see that the price of a Toyota is 11,300 and the prices for Fords are 8,000 and 12,500. Note that the price for an Opel is not specified – we'll explain that later.

Exercise

Examine the result.

When you're done, click Next exercise to continue.