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.
Latihan ini adalah bagian dari kursus
Functions for Manipulating Data in SQL Server
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
SELECT
rating,
-- Round-up the rating to an integer value
___(___) AS round_up
FROM ratings;