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 votes246 views3 answers
Pyodbc connect to sql server
SQL
1 vote226 views1 answer
Get create table query existing table mysql
SQL
1 vote220 views2 answers
Sql multiline comment
SQL
20 votes222 views3 answers
SQL query rename table
SQL
0 vote211 views1 answer
Sql get guid
SQL
1 vote224 views2 answers
Remove space in mysql
SQL
0 vote215 views3 answers
ChAnge TABLE name apex oracle
SQL
1 vote216 views1 answer
Base nosql
SQL
4 votes655 views1 answer
Oracle show errors
SQL
0 vote209 views1 answer
Sql select most frequent value in group
SQL