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 votes215 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
15 votes249 views5 answers
Show tables in oracle
SQL
0 vote256 views1 answer
Sql select merge multiple values
SQL
0 vote198 views1 answer
Sql get count without group by
SQL
0 vote191 views1 answer
Postgresql like
SQL
0 vote196 views1 answer
Sql select non unique
SQL
0 vote282 views1 answer
ORA-01400
SQL
0 vote212 views1 answer
Postgresql regular expression special characters
SQL
0 vote199 views1 answer
Postgresql copy backup table
SQL
1 vote198 views1 answer
Sql run multiple updates in one query
SQL