ROUND

Round numbers to a given number of decimals.

ROUND rounds a number to a given decimal place. The second argument is the digit count; without it rounds to an integer.

SELECT ROUND(price, 2) AS yuvarlak FROM products;

This query rounds prices to 2 decimal places.

ROUND(price, 2) AS yuvarlak is selected from products.

ROUND — details

ROUND(3.1415, 2) = 3.14; ROUND(3.1415) = 3. A negative digit rounds to tens or hundreds: ROUND(1234, -2) = 1200.

Round price to 2 decimal places from products.

Show example solution

SELECT ROUND(price, 2) AS yuvarlak
FROM products

Round

SELECT ____(price, 2) FROM products;

Show answer

SELECT ROUND(price, 2) FROM products;