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 vote300 views1 answer
Microsoft sql server python connection
SQL
13 votes301 views1 answer
Views in sql
SQL
0 vote289 views1 answer
Synapse sql table set pk
SQL
5 votes283 views1 answer
Oracle create table comment
SQL
2 votes325 views2 answers
Oracle create table if not exists
SQL
2 votes271 views1 answer
Select from array in psql
SQL
0 vote284 views1 answer
Sqlite commands
SQL
0 vote319 views1 answer
Netstat -tln mysql
SQL
0 vote282 views1 answer
Create new schema mysql
SQL
0 vote290 views1 answer
Postgres create extension if not exists
SQL