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

4 votes207 views2 answers
Mysql show indexes on table
SQL
3 votes192 views1 answer
Index using in query plsql
SQL
0 vote187 views1 answer
Automate mysql cli query
SQL
-3 votes212 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL
0 vote196 views1 answer
Sql server select top 2 of each group
SQL
3 votes222 views2 answers
Sql add year to date
SQL
3 votes193 views4 answers
Mysql delete duplicate rows
SQL
11 votes217 views2 answers
Mysql set safe mode off
SQL
1 vote212 views1 answer
Sql query row number group by
SQL
0 vote218 views1 answer
Query by column for substring sql
SQL