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

5 votes227 views1 answer
Alter table default value mysql
SQL
24 votes271 views4 answers
Postgres remove database
SQL
1 vote288 views2 answers
Sql server backup table
SQL
0 vote282 views3 answers
Delete in SQL SERVER
SQL
1 vote282 views1 answer
Sql server loop over query
SQL
0 vote272 views1 answer
Start stop mysql linux
SQL
0 vote280 views1 answer
Left join vs inner join performance
SQL
0 vote295 views1 answer
Hibernate dialect property xml for mysql 8
SQL
0 vote256 views1 answer
Sql transact create cursor with dynamic tables
SQL
5 votes262 views1 answer
Purge undo tablespace oracle 11g
SQL