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 vote106 views1 answer
Postgresql like
SQL
0 vote107 views1 answer
Sql from null to not null
SQL
4 votes69 views1 answer
Oracle sleep
SQL
0 vote119 views1 answer
Get schema of table sql
SQL
0 vote99 views3 answers
Sql count condition
SQL
3 votes108 views1 answer
Sql replace character in string in all records
SQL
0 vote103 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote120 views1 answer
Select distinct after join
SQL
1 vote102 views3 answers
Mariadb add foreign key
SQL
0 vote115 views1 answer
Query params sql insert python f string
SQL