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

7 votes307 views4 answers
Lowest salary in sql
SQL
0 vote278 views1 answer
Phpmyadmin mysql conflict
SQL
-1 vote294 views1 answer
Sql set max value in column
SQL
1 vote327 views1 answer
Mysql select row max date
SQL
1 vote312 views1 answer
Epoch time converter in snowflake
SQL
0 vote340 views1 answer
Psql check if sql script is valid
SQL
0 vote290 views1 answer
Postgresql default value boolean
SQL
20 votes311 views3 answers
How to open postgresql in mac
SQL
1 vote307 views1 answer
Mysql how to truncate table with foreign keys
SQL
6 votes291 views2 answers
Join vs union
SQL