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

2 votes178 views1 answer
Mysql sysdate
SQL
3 votes176 views1 answer
Oracle list invalid password ORA-01017
SQL
20 votes162 views2 answers
Mysql bigint max value
SQL
0 vote175 views1 answer
Psql no such file or directory
SQL
0 vote172 views4 answers
Rownum in sql
SQL
1 vote187 views3 answers
Union in sql
SQL
2 votes174 views1 answer
Oracle find unusable indexes
SQL
1 vote174 views1 answer
Size of all tables in a schema oracle
SQL
0 vote164 views1 answer
Mysql events not work
SQL
1 vote177 views1 answer
Sql into vs insert into
SQL