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

8 votes221 views3 answers
Mysql alter table add index
SQL
0 vote267 views1 answer
Create-table-with-index-organization
SQL
-1 vote254 views5 answers
Convert sql to linq query online
SQL
19 votes239 views5 answers
Change column name mysql command line
SQL
0 vote246 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
34 votes232 views6 answers
Sql change data type
SQL
0 vote230 views1 answer
Sql inserted
SQL
0 vote257 views1 answer
Postgres can integer fields be negative
SQL
1 vote225 views1 answer
Mysql order by desc null last
SQL
2 votes254 views1 answer
Search query in mysql
SQL