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

23 votes142 views6 answers
Delete all rows from table sql
SQL
1 vote139 views1 answer
Denied
SQL
5 votes146 views6 answers
Sql add days to date
SQL
0 vote136 views1 answer
Deny select insert update delete sql
SQL
1 vote268 views1 answer
Postgres set column based on another column
SQL
0 vote138 views1 answer
Complete date is 1 year or not sql server
SQL
0 vote118 views2 answers
Avg() sql
SQL
5 votes153 views2 answers
Get number of columns sql
SQL
0 vote148 views1 answer
Minus equivalent in my sql
SQL
0 vote135 views1 answer
Full syntax inner join
SQL