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 vote194 views3 answers
SELECT * FROM
SQL
1 vote196 views1 answer
Mysql drop key
SQL
2 votes178 views1 answer
Import database in mysql command line xampp
SQL
0 vote187 views1 answer
TSQL convert csv to table
SQL
1 vote183 views1 answer
Mysql add fields
SQL
3 votes184 views2 answers
Sql paging query
SQL
37 votes175 views3 answers
Postgresql insert column
SQL
0 vote190 views3 answers
How to run sql query
SQL
3 votes170 views1 answer
Oracle undo tablespace list by user
SQL
8 votes186 views5 answers
Alter table add column with default value
SQL