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

1 vote154 views2 answers
Sql where is not number
SQL
20 votes137 views4 answers
Sqlite create table if not exists
SQL
1 vote147 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote132 views1 answer
Dns slave zone convert
SQL
0 vote130 views1 answer
Cast for print sql
SQL
0 vote141 views1 answer
Geopoint from json mysql function
SQL
2 votes173 views1 answer
Dbms transaction (psql)
SQL
0 vote131 views1 answer
Get yesterday date ISO in psql
SQL
0 vote173 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote129 views4 answers
Forenkey code alchemy sql
SQL