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 vote187 views1 answer
How to pass list as parameter in SQL query
SQL
3 votes148 views3 answers
Create a view postgres
SQL
1 vote175 views1 answer
Sql view where tables have same column name combine results
SQL
1 vote145 views1 answer
Postgres check for foreign key
SQL
0 vote219 views1 answer
Mysql readable output
SQL
2 votes157 views1 answer
Oracle convert run_duration to number
SQL
12 votes149 views4 answers
How to take database dump in postgresql
SQL
2 votes171 views1 answer
Query to find table size in oracle 12c
SQL
0 vote181 views1 answer
Show all mongodb
SQL
0 vote138 views2 answers
Clear window pl sql
SQL