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

0 vote121 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
5 votes124 views2 answers
Sql create tabel with primary key auto_increment code
SQL
2 votes151 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
7 votes121 views3 answers
SQL create a new table
SQL
1 vote125 views1 answer
Oracle apex prevent initial load
SQL
8 votes127 views6 answers
Sql insert
SQL
1 vote118 views1 answer
Ilike for date postgres
SQL
2 votes177 views1 answer
Oracle trace session
SQL
0 vote123 views1 answer
Mysql find db contarint
SQL
0 vote176 views1 answer
Get last inserted primary key
SQL