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 vote210 views1 answer
How to map sql column to custom names
SQL
0 vote237 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
3 votes203 views6 answers
DB::table('users')->get();
SQL
0 vote234 views1 answer
Mysql bind-address default value
SQL
0 vote198 views1 answer
Oracle sql copy table without data
SQL
0 vote251 views1 answer
Cartesian product sql
SQL
0 vote287 views1 answer
Mysql collation portugues brasil
SQL
0 vote186 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
0 vote231 views1 answer
Set mysql socket file docker windows
SQL
0 vote200 views1 answer
Cast float mysql
SQL