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
14. NULLIF() – practice 1
Summary

Instruction

Good. Let's do another exercise to practice the use of NULLIF().

Exercise

Show the Name of each product with the Ratio calculated in the following way: 

Divide the Price of the product by its ShippingCost.
Show the result in percent, rounded to an integer value.

If the ShippingCost is 0.00, show NULL instead.

Stuck? Here's a hint!

Use the function ROUND(x, 0) to get the rounded value. There is no need to append the percent sign.