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

0 vote355 views1 answer
Heidisql check how much space a row
SQL
0 vote353 views1 answer
Qt qsql check if table exist
SQL
6 votes354 views4 answers
How to remove unique key in mysql
SQL
0 vote347 views1 answer
Opensuse stop MySQL
SQL
2 votes346 views1 answer
Select * from table where name like
SQL
0 vote299 views1 answer
Mysql insert with foreign key
SQL
0 vote348 views1 answer
Mssql view column data type
SQL
0 vote377 views3 answers
Fetlife
SQL
1 vote378 views2 answers
Mysql trim spaces
SQL
2 votes348 views2 answers
How to DROP a table in mysql
SQL