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 vote115 views1 answer
Sql getdate minus 1 day without time
SQL
0 vote108 views1 answer
SQL Error 1040 : Too many connections
SQL
1 vote130 views3 answers
Update from select sqlite
SQL
1 vote97 views1 answer
Mysql stop password policy
SQL
4 votes121 views2 answers
Mysql delete user if exists
SQL
0 vote149 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote116 views1 answer
List all indexes postgres
SQL
0 vote135 views1 answer
Sql show founctions
SQL
13 votes109 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote115 views1 answer
Basic structure of sql expression having clause
SQL