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

4 votes133 views4 answers
Print pl sql
SQL
2 votes140 views3 answers
Row number mysql
SQL
0 vote142 views1 answer
Sql express database size limit
SQL
0 vote186 views1 answer
Oracle show running job
SQL
1 vote129 views1 answer
Mysql get character set
SQL
0 vote121 views1 answer
Insert thai language sql server
SQL
0 vote164 views2 answers
While mysql
SQL
10 votes141 views6 answers
Between sql
SQL
0 vote135 views3 answers
Select random sql
SQL
0 vote144 views1 answer
Sql include rows with 0 values
SQL