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 vote232 views1 answer
Mysql show long running queries
SQL
0 vote282 views1 answer
How to add auto increment primary key
SQL
4 votes216 views2 answers
Insert current date in mysql
SQL
0 vote224 views2 answers
Return the number of records in a single table mysql
SQL
21 votes226 views4 answers
Add column mssql
SQL
0 vote231 views1 answer
Sql delete caracter list
SQL
1 vote221 views3 answers
Default password of mysql
SQL
24 votes219 views2 answers
Alter table delete column
SQL
3 votes220 views2 answers
Sqlite show table definition
SQL
0 vote235 views1 answer
Varchar2 length in oracle
SQL