YouTip

Sql Func Round

📅 2026-06-18 | 📂 SQL

SQL ROUND() Function

SQL ROUND() Function

-- Learning Not Just Technology, But Dreams!

SQL Tutorial

SQL Tutorial SQL Introduction SQL Syntax SQL SELECT SQL SELECT DISTINCT SQL WHERE SQL AND & OR SQL ORDER BY SQL INSERT INTO SQL UPDATE SQL DELETE

SQL Advanced Tutorial

SQL SELECT TOP SQL LIKE SQL Wildcards SQL IN SQL BETWEEN SQL Aliases SQL JOIN SQL INNER JOIN SQL LEFT JOIN SQL RIGHT JOIN SQL FULL JOIN SQL UNION SQL SELECT INTO SQL INSERT INTO SELECT SQL CREATE DATABASE SQL CREATE TABLE SQL Constraints SQL NOT NULL SQL UNIQUE SQL PRIMARY KEY SQL FOREIGN KEY SQL CHECK SQL DEFAULT SQL CREATE INDEX SQL DROP SQL ALTER SQL Auto Increment SQL Views SQL Dates SQL NULL Values SQL NULL Functions SQL General Data Types SQL DB Data Types

SQL Functions

SQL Functions SQL AVG() SQL COUNT() SQL FIRST() SQL LAST() SQL MAX() SQL MIN() SQL SUM() SQL GROUP BY SQL HAVING SQL EXISTS SQL UCASE() SQL LCASE() SQL MID() SQL LEN() SQL ROUND() SQL NOW() SQL FORMAT() SQL Quick Reference SQL Injection SQL Quiz SQL Hosting SQL Summary

SQL LEN() Function

SQL NOW() Function

Explore In Depth

Programming

DATABASE

Data Management

Programming Languages

Development Tools

Web Design & Development

Scripting

Web Services

Scripting Languages

Computer Science

SQL ROUND() Function

ROUND() Function

The ROUND() function is used to round a numeric field to the number of decimals specified.

SQL ROUND() Syntax

SELECT ROUND(column_name, decimals)
FROM TABLE_NAME;

Parameter	Description
column_name	Required. The field to round.
decimals	Optional. Specifies the number of decimals to return.

SQL ROUND() Examples

ROUND(X): Returns the argument X, rounded to an integer.

Example

mysql> SELECT ROUND(-1.23);
        -> -1

mysql> SELECT ROUND(-1.58);
        -> -2

mysql> SELECT ROUND(1.58);
        -> 2

ROUND(X,D): Returns the argument X, rounded to D decimal places. If D is 0, the result will have no decimal point or fractional part.

Example

mysql> SELECT ROUND(1.298, 1);
        -> 1.3

mysql> SELECT ROUND(1.298, 0);
        -> 1

Note: The ROUND return value is converted to a BIGINT!