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 vote351 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
1 vote354 views1 answer
Describe table in sql
SQL
0 vote358 views2 answers
Dbms interview questions
SQL
0 vote345 views3 answers
Mysqli count down
SQL
9 votes383 views3 answers
Mysql run sql file
SQL
0 vote328 views1 answer
Create table employees oracle
SQL
0 vote384 views2 answers
Mysql two column combination unique
SQL
0 vote354 views1 answer
Get relation data in mysql using query to excel
SQL
-1 vote345 views2 answers
On update cascade
SQL
0 vote397 views1 answer
Acutal month year
SQL