SQL ROUND()

ROUND(x, d) 把数值四舍五入到 d 位小数；d 为负时对整数位舍入。

Beginner

Key PointsSQL,ROUND,四舍五入

讲解

ROUND(x, d) 把数值四舍五入到 d 位小数；d 为负时对整数位舍入。

SQL

SELECT ROUND(1.456, 2) AS r1, ROUND(123.456, -1) AS r2;

Output

r1     r2
-----  -----
1.46   120

ROUND(x, d) 把数值四舍五入到 d 位小数；d 为负时对整数位舍入。

SQL

SELECT ROUND(1.456, 2) AS r1, ROUND(123.456, -1) AS r2;

Output

r1     r2
-----  -----
1.46   120