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 vote339 views1 answer
Sql case sttement with set
SQL
1 vote342 views1 answer
Mysql workbench in ubuntu 14.04
SQL
1 vote356 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote336 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote400 views1 answer
Remove mysql from centos 7
SQL
0 vote343 views1 answer
How to order result of subquery in select
SQL
0 vote323 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote364 views1 answer
Alter table change default
SQL
12 votes323 views1 answer
How to change the value of a table in sql
SQL
6 votes350 views3 answers
Oracle all dates between two dates
SQL