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 vote199 views1 answer
Where case insensitive like mysql
SQL
0 vote205 views1 answer
How to install mysql without admin rights
SQL
1 vote199 views3 answers
Grant syntax in sql
SQL
1 vote222 views2 answers
Oracle leftmost characters
SQL
0 vote210 views1 answer
Database traccar
SQL
19 votes227 views3 answers
How to change column type psql
SQL
8 votes221 views1 answer
Ltrim sql
SQL
5 votes230 views3 answers
Show indexes mysql
SQL
44 votes260 views4 answers
Mysql alter table add column first
SQL
0 vote200 views1 answer
Check mysql password with docker container magento 2
SQL