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 vote162 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote161 views1 answer
Delete duplicate rows
SQL
-1 vote156 views1 answer
Get id from just inserted row mysql server python
SQL
1 vote142 views1 answer
Use of now() in mysql
SQL
3 votes251 views2 answers
Savepoint in sql
SQL
0 vote153 views1 answer
Postgresql where clause not working
SQL
3 votes155 views1 answer
Pl sql escape &
SQL
0 vote172 views1 answer
Str_to_date sql server
SQL
0 vote152 views2 answers
Sql drop view if exists
SQL
0 vote157 views1 answer
Move table to a different schema
SQL