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

6 votes787 views3 answers
Sql select last id
SQL
1 vote344 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote347 views1 answer
Mysql insert into select with recursive
SQL
0 vote344 views2 answers
Postgresql display subquery as json
SQL
0 vote354 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote336 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote374 views1 answer
Mysql collation portugues brasil
SQL
0 vote327 views1 answer
SQL get max per id
SQL
6 votes375 views2 answers
Mysql execute file
SQL
0 vote359 views1 answer
Sql select duplicates based on two columns
SQL