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

9 votes247 views6 answers
Replace sql
SQL
4 votes229 views1 answer
Psql get sequences
SQL
57 votes350 views6 answers
Sql alter table
SQL
0 vote243 views1 answer
Execut sql python
SQL
0 vote232 views1 answer
Mysql add comment to column
SQL
0 vote244 views1 answer
Dbms_output sql developer
SQL
4 votes244 views3 answers
Postgres set default value
SQL
2 votes228 views2 answers
Mysql limit
SQL
0 vote235 views1 answer
Snap craft
SQL
0 vote226 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL