Rounding numbers
Sometimes in your database development, you may need to round the results of a calculation. There are three functions you can use for this:
CEILING(expression): rounds-up to the nearest integer valueFLOOR(expression): rounds-down to the nearest integer valueROUND(expression, length): rounds the expression to the specified length.
In this exercise, you will get familiar with the rounding functions, by applying them on a query based on the ratings table.
Diese Übung ist Teil des Kurses
Functions for Manipulating Data in SQL Server
Interaktive Übung
Vervollständige den Beispielcode, um diese Übung erfolgreich abzuschließen.
SELECT
rating,
-- Round-up the rating to an integer value
___(___) AS round_up
FROM ratings;