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

8 votes404 views1 answer
Mysql limit rows
SQL
0 vote393 views1 answer
Oracle grant create job
SQL
0 vote352 views2 answers
Sql 2 way of select unique
SQL
3 votes423 views1 answer
Oracle sql commit example
SQL
16 votes358 views2 answers
Add column to all tables after first column mysql
SQL
0 vote362 views1 answer
Oracle archivelog usage
SQL
0 vote369 views1 answer
Windows aggregate functions in postgresql
SQL
5 votes338 views1 answer
Oracle asynchronous procedure
SQL
0 vote358 views1 answer
Show database not empty tables postgres
SQL
57 votes599 views6 answers
Mysql alter table add column
SQL