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 vote318 views1 answer
IS THEre any difference between using default and := in plsql
SQL
-1 vote339 views1 answer
Module operator in oracle sql
SQL
33 votes397 views6 answers
Sql delete
SQL
0 vote307 views1 answer
Zsh: command not found: mysql mamp
SQL
4 votes321 views1 answer
Select first and last row sql
SQL
1 vote321 views1 answer
Select from one table where not on the other
SQL
0 vote361 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote325 views1 answer
Sqlalchemy case insensitive like
SQL
8 votes366 views1 answer
Mysql limit rows
SQL
14 votes348 views1 answer
Oracle new column
SQL