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

3 votes347 views2 answers
Monthname sql
SQL
3 votes379 views5 answers
Duplicate table sql
SQL
0 vote369 views1 answer
Call object contructor and call methods of object
SQL
0 vote336 views1 answer
Limit and offset in stored procedure mssql
SQL
1 vote356 views1 answer
Tsql get beginning of year
SQL
0 vote335 views1 answer
Xampp mysql version
SQL
0 vote372 views1 answer
Ajouter une clé etrangere mysql
SQL
0 vote307 views0 answer
SQL
8 votes344 views3 answers
Alter table auto_increment
SQL
1 vote354 views1 answer
SQL Integer devision
SQL