Number(10 2) in sql means

-- Precision of 10 and a scale of 2
SELECT CONVERT(DECIMAL(10, 2), col_name)

SELECT CONVERT(DECIMAL(10, 2), 2.999999)			-- 3.00
SELECT CONVERT(DECIMAL(10, 2), 12352.334)			-- 12352.33
SELECT CONVERT(DECIMAL(10, 2), 12564258524132.336)	-- Error: data truncation

Similar codes

1 vote218 views1 answer
Where to locate set password for mysql
SQL
0 vote209 views1 answer
Oracle list user locked
SQL
0 vote215 views1 answer
Postgresql cast as year and month from timestamp
SQL
15 votes210 views6 answers
Psql
SQL
0 vote217 views1 answer
Oracle swap partition
SQL
1 vote211 views1 answer
Mysql copy table1 to table2
SQL
0 vote256 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
1 vote204 views1 answer
Mysql show table character set
SQL
0 vote212 views1 answer
How to add unique key constraint in mysql
SQL
0 vote220 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL