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 vote236 views1 answer
Mysql remove last character
SQL
0 vote207 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote179 views1 answer
18446744073709551615 mariadb left join order by
SQL
1 vote189 views1 answer
Set statiscis on in ssms
SQL
38 votes247 views6 answers
Alter table mysql
SQL
0 vote191 views1 answer
Oracle query to find schema you are working on
SQL
8 votes183 views2 answers
Replace string value in sql
SQL
1 vote183 views1 answer
Install postgresql on raspberry pi
SQL
0 vote185 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote167 views1 answer
Alter boolean column postgresql
SQL