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 vote286 views1 answer
Mysql event last execution
SQL
1 vote278 views1 answer
Top 10 rows in mysql
SQL
12 votes307 views6 answers
Distinct in sql server
SQL
0 vote242 views1 answer
Mysql timeout 30 seconds
SQL
0 vote340 views1 answer
Plpgsql create function
SQL
1 vote324 views1 answer
STOP message of how many rows affected sql
SQL
8 votes293 views1 answer
Oracle add datafile to tablespace
SQL
0 vote259 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote261 views1 answer
Python mysql query where
SQL
1 vote292 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL