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

0 vote206 views1 answer
Mysql get last 2 month data
SQL
0 vote202 views1 answer
Sql select inside select sub query
SQL
42 votes290 views6 answers
Rename table sql server
SQL
8 votes186 views5 answers
Grant permission in postgres
SQL
22 votes208 views3 answers
Remove all records from table mysql
SQL
0 vote230 views1 answer
Openquery update linked server
SQL
1 vote188 views4 answers
Sequelize migration default value
SQL
1 vote207 views1 answer
Show structure of table in sql
SQL
2 votes239 views1 answer
Sql string starts with
SQL
0 vote186 views1 answer
Lost connection to mysql
SQL