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 vote118 views1 answer
Oracle sql pad left zeros
SQL
0 vote99 views1 answer
Difference between varchar and varchar2
SQL
1 vote96 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote100 views1 answer
Mysql create table like
SQL
-1 vote55 views2 answers
Datetime sql server week
SQL
-1 vote94 views3 answers
Mysql get age from date
SQL
0 vote98 views1 answer
How to fix mysql stop unexpectedly
SQL
0 vote105 views2 answers
Alter table add multiple columns mysql
SQL
0 vote110 views1 answer
Oracle cpu metric
SQL
0 vote158 views1 answer
Connect google bigquery connect using sqirrel
SQL