ROUND(23.298, -1) : ROUND : Math Numeric Functions MySQL TUTORIALS

MySQL TUTORIALS » Math Numeric Functions » ROUND »

ROUND(23.298, -1)


mysql>
mysql> SELECT ROUND(23.298, -1);
+-------------------+
| ROUND(23.298, -1) |
+-------------------+
|                20 |
+-------------------+
1 row in set (0.00 sec)

mysql>
mysql>

Related Scripts with Example Source Code in same category :

ROUND(X), ROUND(X,D) rounds the argument X to D decimal places.
ROUND(1.298, 1)
ROUND(1.298, 0)
ROUND(150.000,2)/ROUND(150,2)
Rounding value in a column
How rounding differs for exact and approximate values

MySQL TUTORIALS

Math Numeric Functions
» ROUND

Aggregate Functions

Cast Functions Operators

Comparison Functions Operators

Control Flow Functions

Cursor

Data Dictionary

Data Types

Database

Date Time Functions

Encryption Compression Functions

Information Functions

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Miscellaneous Functions

Privilege

Subquery

Table

Table Join

Trigger

View

ROUND(23.298, -1) : ROUND : Math Numeric Functions MySQL TUTORIALS

MySQL TUTORIALS » Math Numeric Functions » ROUND »

ROUND(23.298, -1)

Leave a Comment / Note

MySQL TUTORIALS