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 vote323 views1 answer
Mysql select smaller of two values
SQL
1 vote310 views1 answer
Oracle split string
SQL
1 vote304 views1 answer
Loading local data is disabled mysql
SQL
13 votes296 views2 answers
Sqlite rename column
SQL
0 vote337 views1 answer
How to write if case in select query in select statement
SQL
-1 vote338 views2 answers
Postgres autoincrement primary key
SQL
0 vote343 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote336 views2 answers
Mysql calcular idade
SQL
0 vote305 views1 answer
Time mysql w3
SQL
11 votes338 views2 answers
Mysql disable safe mode
SQL