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 vote143 views1 answer
Oracle webcenter content search enginer
SQL
1 vote145 views1 answer
Calculate age in sql postgresql
SQL
4 votes180 views1 answer
Rename stored procedure in sql server
SQL
0 vote114 views1 answer
Sql injection mitigation
SQL
1 vote142 views1 answer
Oracle list constraints
SQL
1 vote194 views2 answers
Truncate table sqlite
SQL
14 votes147 views3 answers
How to add default constraint in mysql
SQL
0 vote157 views1 answer
Php select data from mysql database without column name
SQL
0 vote132 views1 answer
Check if table exists oracle
SQL
1 vote160 views1 answer
Oracle user last connection date
SQL