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 votes177 views6 answers
Mysql change timezone
SQL
2 votes173 views1 answer
Laravel sql String
SQL
24 votes152 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote171 views2 answers
How to start postgresql laravel
SQL
9 votes153 views2 answers
Cmd to rename a collumn name in sql
SQL
1 vote162 views1 answer
Postgres check blocking
SQL
1 vote187 views1 answer
Add many column to sap iq table
SQL
0 vote250 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
11 votes185 views1 answer
Oracle insert from select
SQL
0 vote160 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL