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 vote128 views1 answer
Oracle create_program
SQL
10 votes111 views4 answers
How to alter table name in mysql
SQL
0 vote378 views1 answer
Create pl/sql stored procedure
SQL
0 vote136 views1 answer
Rails sql query converstion
SQL
0 vote167 views1 answer
Parent and child link in mysql
SQL
1 vote115 views1 answer
MySQL AND Operator
SQL
24 votes122 views4 answers
Postgres remove database
SQL
0 vote109 views1 answer
Django how to get query result count
SQL
0 vote117 views1 answer
Drop a field in psql django
SQL
1 vote123 views1 answer
Oracle user last connection date
SQL