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 vote258 views3 answers
Magento 2 order delete from db
SQL
0 vote273 views1 answer
Query builder doctrien return sql
SQL
0 vote250 views4 answers
Mysql select bottom 10 rows
SQL
0 vote280 views2 answers
Compound operator in sql
SQL
1 vote249 views1 answer
Base nosql
SQL
16 votes267 views1 answer
Mysql smallint range
SQL
0 vote246 views1 answer
Remove default constraint sql server
SQL
0 vote238 views1 answer
Check if a word appears at the end sql query
SQL
0 vote251 views1 answer
Events not working db
SQL
0 vote290 views1 answer
How to get button for every record from mysql
SQL