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

0 vote148 views1 answer
Mysql query to select the highest value
SQL
1 vote142 views1 answer
SQL query to get all table records count from a database
SQL
0 vote137 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote128 views1 answer
Oracle tablespace autoextend
SQL
1 vote135 views3 answers
Union SQL
SQL
0 vote147 views1 answer
Get max salary from each department sql
SQL
0 vote208 views1 answer
Connect google bigquery connect using sqirrel
SQL
1 vote145 views1 answer
Mysql find most common value
SQL
0 vote146 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
2 votes153 views4 answers
2nd highest salary in mysql
SQL