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 vote167 views1 answer
Copying query result to excel
SQL
0 vote166 views1 answer
If null don't update
SQL
7 votes200 views1 answer
Mysql unsafe update
SQL
0 vote160 views1 answer
Call function sql oracle
SQL
0 vote259 views1 answer
How to show current database in mysql
SQL
20 votes167 views2 answers
Mysql bigint max value
SQL
1 vote286 views3 answers
Uninstall postgresql mac
SQL
5 votes197 views1 answer
How to check port number for postgresql
SQL
0 vote186 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL
0 vote173 views1 answer
Hoq to import database source
SQL