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

4 votes327 views2 answers
How to count items with same name in sql
SQL
6 votes792 views3 answers
Sql select last id
SQL
5 votes360 views3 answers
Sql max value in column
SQL
0 vote358 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote330 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote354 views3 answers
Average salary in sql
SQL
0 vote398 views1 answer
Sql ssrs
SQL
0 vote338 views1 answer
Bigquery declare
SQL
-1 vote356 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote359 views3 answers
Query string not ending with with vowels
SQL