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

6 votes305 views6 answers
Count mysql
SQL
0 vote347 views1 answer
Oracle pl/sql check if file exists
SQL
1 vote317 views3 answers
Showing all columns in an sqlite table
SQL
1 vote269 views1 answer
Database run
SQL
0 vote322 views1 answer
How to print some string in mysql
SQL
1 vote309 views1 answer
Postgres start database on linux
SQL
0 vote299 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote329 views1 answer
Firebase sql
SQL
0 vote304 views1 answer
Show create table in postgresql
SQL
16 votes363 views1 answer
Mysql mediumint max value
SQL