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.
Este exercício faz parte do curso
Functions for Manipulating Data in SQL Server
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
SELECT
rating,
-- Round-up the rating to an integer value
___(___) AS round_up
FROM ratings;