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 vote324 views1 answer
Hibernate xml property MySQL url, username and password
SQL
3 votes309 views1 answer
How to remove characters from string in mysql
SQL
0 vote361 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
2 votes332 views1 answer
Sql to char function with date
SQL
0 vote326 views1 answer
How to export only procedures mysql
SQL
0 vote325 views1 answer
Mysql bind-address default value
SQL
1 vote313 views1 answer
Oracle explain plan
SQL
14 votes342 views1 answer
Excel
SQL
4 votes321 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote312 views1 answer
Convert rows to string sql server
SQL