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 vote333 views1 answer
Show databases mysql docker
SQL
0 vote289 views1 answer
Sqlalchemy query return only n results
SQL
0 vote306 views1 answer
T-SQL Create Trigger
SQL
4 votes297 views3 answers
Copy table postgres
SQL
0 vote285 views1 answer
Hive batch drop table
SQL
0 vote348 views1 answer
Drop view sql
SQL
0 vote318 views1 answer
Postgres change the name of schema
SQL
0 vote336 views1 answer
Error code 1451 sql
SQL
0 vote313 views1 answer
Mysql 8 geo to json
SQL
1 vote310 views1 answer
Table information in sql server
SQL