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

3 votes126 views2 answers
Sql add year to date
SQL
2 votes144 views1 answer
Sql server current date minus 5 years
SQL
10 votes133 views4 answers
SELECT FROM WHERE
SQL
0 vote131 views1 answer
T-sql check if data exists
SQL
0 vote122 views1 answer
How to connect pgadmin with excel
SQL
0 vote122 views1 answer
Enable outgoing remote MySQL access
SQL
6 votes170 views2 answers
Install psql mac
SQL
2 votes127 views1 answer
Select * from table where name like
SQL
0 vote173 views1 answer
Sql select without column name
SQL
-1 vote163 views1 answer
Mysql faster insert
SQL