دالة ROUND()

ROUND(number, decimal_places)

SELECT ROUND(3.7);
-- Returns 4.0

SELECT ROUND(3.3);
-- Returns 3.0

SELECT ROUND(3.5);  
-- Returns 4.0 (rounds up from .5)

SELECT ROUND(3.14159, 2);
-- Returns 3.14

SELECT ROUND(3.14159, 1);
-- Returns 3.1

SELECT ROUND(3.14159, 0);
-- Returns 3.0

SELECT ROUND(3.145, 2);
-- Returns 3.15 (rounds up because the next digit is 5)

SELECT 
    product_name,
    ROUND(price, 2) as rounded_price
FROM products;