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

13 votes183 views4 answers
Mysql select last 10 rows
SQL
0 vote213 views1 answer
Select all same column value in sql
SQL
1 vote173 views1 answer
Importance of comment in mysql
SQL
5 votes253 views1 answer
Migrate sql table another database
SQL
0 vote224 views1 answer
Search In the Data using ObjectName
SQL
0 vote186 views1 answer
Ansi sql count duplicate rows
SQL
9 votes218 views1 answer
Identity insert on sql server
SQL
0 vote136 views1 answer
Update sql join multiple tables
SQL
0 vote194 views1 answer
C# execute transact sql
SQL
0 vote198 views1 answer
Mysql get last 2 month data
SQL