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

25 votes244 views3 answers
How to use a database to see tables mysql
SQL
0 vote246 views1 answer
Sql server rtrim everything after character
SQL
0 vote195 views1 answer
Select all domains of database firbird
SQL
0 vote246 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote317 views1 answer
Delet all record statment sql
SQL
-1 vote220 views1 answer
MYSQL stored procedure select from
SQL
0 vote226 views1 answer
Sql contains vs like
SQL
24 votes238 views6 answers
Rename a column in sql server
SQL
0 vote249 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
0 vote208 views1 answer
Count column of tables psql
SQL