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

2 votes287 views1 answer
Oracle apex who is connected
SQL
0 vote293 views2 answers
Mysql row_number() example
SQL
12 votes290 views1 answer
Script to add new column in table sql
SQL
3 votes289 views2 answers
Sqlite print all column names
SQL
0 vote274 views1 answer
Sql datediff month
SQL
2 votes318 views1 answer
Select a certain number of entries from select mysql
SQL
-1 vote340 views1 answer
Difference berween database and data base management system
SQL
0 vote291 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote331 views2 answers
Sql unique
SQL
1 vote293 views1 answer
Use of now() in mysql
SQL