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 vote64 views1 answer
Bigquery information_schema schema all columns
SQL
1 vote103 views1 answer
Where date = max(date) in sql
SQL
0 vote114 views1 answer
Duplix print in Smartforms
SQL
1 vote103 views1 answer
Setval pgsql
SQL
25 votes108 views3 answers
How to use a database to see tables mysql
SQL
0 vote109 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
1 vote118 views1 answer
Describe table in sql
SQL
0 vote144 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote161 views1 answer
MySQL update with subquery
SQL
5 votes129 views3 answers
Db begintransaction laravel
SQL