SQL rounding numbers

Sql limit decimal places

SELECT CAST(ROUND(125.025000, 2) AS NUMERIC(36,2))
returns: 125.03

Source: stackoverflow.com

SQL rounding numbers

SELECT 2.555555; --> Result 2.555555
SELECT ROUND(2.555555); --> Result 3
SELECT ROUND(2.555555, 3); --> Result 2.556
SELECT ROUND(2.555555, 0); --> Result 3

Similar codes

-1 vote201 views2 answers
Get day in sql
SQL
19 votes222 views3 answers
Grant mysql
SQL
7 votes218 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
1 vote190 views1 answer
Oracle truncate partition
SQL
10 votes192 views4 answers
Join with multiple conditions sql
SQL
2 votes216 views1 answer
SQL column name Postgre
SQL
3 votes202 views3 answers
How to add month in update sql
SQL
4 votes198 views2 answers
Mysql select where starts with
SQL
2 votes217 views2 answers
Mysql add hours to time field
SQL
9 votes212 views3 answers
Sql delete where in
SQL