SQL · Functions and expressions

round()

Rounds a numeric value.

sqlRunnable example sql course

Syntax

round(value, places)

Example

Open in the lab

SELECT round(3.14159, 2) AS pi;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.