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 vote221 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote208 views1 answer
If null don't update
SQL
9 votes183 views1 answer
Mysql check date range
SQL
9 votes194 views2 answers
Get first 3 letters in sql
SQL
0 vote217 views1 answer
Mysql persistence.xml
SQL
0 vote206 views1 answer
Get date ISO in psql
SQL
-1 vote204 views1 answer
Count occurrences sql
SQL
2 votes208 views1 answer
How to get weekday from old date in sql
SQL
-2 votes203 views1 answer
Create trigger syntax
SQL
0 vote181 views1 answer
Dasebase_url-postgres for windows
SQL