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 vote219 views1 answer
Postgres foreign key multiple columns
SQL
0 vote189 views1 answer
Oracle chain step succeeded
SQL
3 votes220 views2 answers
Enter mysql command line
SQL
0 vote206 views1 answer
Original Query
SQL
0 vote149 views1 answer
Sub blocks in sql
SQL
3 votes180 views1 answer
V$session not found in oracle
SQL
0 vote171 views1 answer
SQL FROM-Klausel
SQL
0 vote160 views4 answers
Mysql count table rows
SQL
0 vote177 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote173 views1 answer
Mysql make date from 2 column
SQL