Round in sql

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

Round in sql

SELECT ROUND (commission_pct, 0)
From employees;

Round up and down sql

SQL ROUND UP AND ROUND DOWN

-1

Source: blog.sqlauthority.com

Similar codes

5 votes143 views2 answers
Postgresql insert select
SQL
0 vote117 views1 answer
Postgresql certain first 4 characters in string
SQL
1 vote129 views1 answer
Sql trigger before delete
SQL
0 vote129 views2 answers
Oracle sql for each row
SQL
10 votes137 views2 answers
SQL rounding numbers
SQL
0 vote135 views1 answer
Sparql list all graphs
SQL
0 vote135 views3 answers
How to run sql query
SQL
0 vote157 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
4 votes133 views1 answer
Data types in sql
SQL
1 vote124 views1 answer
Sql where last 12 months
SQL