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 vote107 views1 answer
Show table details postgresql
SQL
9 votes104 views4 answers
Mysql show table fields
SQL
0 vote101 views1 answer
Call rest api from postgresql
SQL
4 votes128 views2 answers
Dbms output
SQL
15 votes104 views4 answers
How to get all tables in sql
SQL
1 vote52 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
1 vote189 views1 answer
Mysql breakline on string
SQL
0 vote104 views1 answer
Sql query wordpress export post
SQL
4 votes120 views3 answers
Mysql get column names from table
SQL
5 votes130 views1 answer
Migrate sql table another database
SQL