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

Introduction
The ISNULL() function
The COALESCE() function
The NULLIF() function
Summary
18. Exercise 2

Instruction

That's very good! Let's see how you fare with Exercise 2.

Exercise

For each product, show its:

  • ID,
  • type (name the column ProductType),
  • LaunchDate (name the column NewLaunchDate).

If the LaunchDate is NULL, show the current date instead. If there is no product type, show N'no type'. Order the results by NewLaunchDate, with the oldest dates appearing first.

Stuck? Here's a hint!

It's a quiz. No hints this time!