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 vote200 views1 answer
Join first name and last name sql
SQL
0 vote240 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote214 views2 answers
Port 5432 is already in use mac
SQL
0 vote232 views1 answer
How to get parent and child record in single query using sql
SQL
0 vote197 views1 answer
Top frequency in sql server
SQL
1 vote223 views1 answer
Sample in sql
SQL
3 votes222 views1 answer
Oracle undo tablespace schema
SQL
0 vote206 views1 answer
Null column as zero in mysql
SQL
1 vote256 views1 answer
Postgres count string length
SQL
0 vote207 views1 answer
Oracle gather table statistics
SQL