ROUND()
ROUND() is a SQL function in the Numeric Functions category. Rounds a number to a specified number of decimal places. The syntax is ROUND(number, decimals). It accepts number, decimals. It returns rounded number. A typical example: SELECT ROUND(3.14159, 2); -- 3.14 SELECT ROUND(price, 0) FROM products; -- Round to integer A close relative is ABS(), which returns the absolute (positive) value of a number. A close relative is CEIL() / CEILING(), which returns the smallest integer greater than or equal to a number (rounds up). A close relative is FLOOR(), which returns the largest integer less than or equal to a number (rounds down). More about this category: Mathematical functions — ROUND, ABS, CEIL, FLOOR, POWER, SQRT, MOD. Related Numeric Functions entries: ABS(), CEIL() / CEILING(), FLOOR(), POWER() / POW(), SQRT(), MOD(), GREATEST() / LEAST(), RAND() / RANDOM().