CommencerCommencer gratuitement

Rounding numbers

All the prices of songs end with .99. There are some countries that have phased out pennies, like Canada. In order to comply with this, you have been asked to convert UnitPrice in the Track table to the nearest whole number (e.g., $1.99 to $2).

In the video, we covered ROUND() and TRUNC(), which do you need to accomplish this task?

Cet exercice fait partie du cours

Introduction to Oracle SQL

Afficher le cours

Instructions

  • Select the TrackId and UnitPrice column from Track.
  • Use a function on UnitPrice to round up to the nearest whole number.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de code.

-- Select TrackId and rounded unit price
SELECT ___, ___
FROM ___
Modifier et exécuter le code