SQL rounding numbers

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

Similar codes

0 vote223 views1 answer
Implode in sql query
SQL
0 vote212 views1 answer
Postgres list users and roles
SQL
-1 vote201 views1 answer
Search all sql tables for a value
SQL
0 vote200 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
1 vote191 views1 answer
Join to find results not in another table
SQL
8 votes196 views1 answer
Oracle create datafile
SQL
0 vote201 views1 answer
Lesser than or equal to symbol in postgres
SQL
0 vote227 views1 answer
Mysql faster delete
SQL
-1 vote193 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote201 views1 answer
Value of sold product using having and group by in sql
SQL