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

1 vote214 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
25 votes178 views6 answers
How to change column name in mysql
SQL
0 vote163 views1 answer
Sql requete number pair
SQL
2 votes151 views2 answers
How to view created temporary tables in mysql
SQL
1 vote172 views1 answer
Oracle drop job if exists
SQL
18 votes120 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote167 views3 answers
Fetlife
SQL
7 votes160 views2 answers
Oracle sql drop index
SQL
14 votes154 views2 answers
Oracle add column with default value
SQL
0 vote194 views1 answer
How many rows affected in sqllite
SQL