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

5 votes135 views2 answers
Oracle list columns schema
SQL
0 vote159 views1 answer
Oracle search in date columns
SQL
0 vote151 views2 answers
Sql drop view if exists
SQL
3 votes162 views1 answer
Sql print all names that start with a given letter
SQL
0 vote112 views1 answer
Mysql date + 1 day
SQL
0 vote148 views1 answer
Django how to get query result count
SQL
11 votes288 views2 answers
Import mysql dump command line windows
SQL
0 vote163 views1 answer
Sql server user permissions and roles
SQL
2 votes140 views1 answer
How to delete columns in sql
SQL
1 vote154 views4 answers
Postgres extract date from timestamp
SQL