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 vote143 views3 answers
Union SQL
SQL
0 vote155 views1 answer
Mysql url data type
SQL
0 vote203 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
1 vote138 views2 answers
Mysql allow remote connections
SQL
21 votes150 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote206 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
0 vote161 views2 answers
Update query with between in mysql
SQL
0 vote138 views2 answers
How to get json data mysql
SQL
1 vote146 views1 answer
Mysql view command
SQL
1 vote154 views2 answers
Reset mysqli fetch_arra
SQL