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

1 vote290 views1 answer
Mysql check if string contains comma separated
SQL
3 votes257 views2 answers
Oracle sql truncate table
SQL
0 vote251 views1 answer
Wordpress sql find and replace
SQL
2 votes291 views1 answer
Mysql set value as null
SQL
1 vote278 views1 answer
Events mysql
SQL
4 votes277 views2 answers
Mysql delete user if exists
SQL
0 vote301 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
3 votes260 views4 answers
Mysql create table from select statement
SQL
0 vote272 views1 answer
Prepared statement mysql java delete selected rows
SQL
0 vote251 views1 answer
Postgres float to int
SQL