Get startedGet started for free

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 value
  • FLOOR(expression): rounds-down to the nearest integer value
  • ROUND(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.

This exercise is part of the course

Functions for Manipulating Data in SQL Server

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT
	rating,
	-- Round-up the rating to an integer value
	___(___) AS round_up
FROM ratings;
Edit and Run Code