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 vote167 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote176 views1 answer
Create bdd mysql
SQL
1 vote229 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote172 views1 answer
How to save data in database in mysql node
SQL
0 vote183 views1 answer
Replace divide by zero error with 0 in sql
SQL
8 votes216 views6 answers
Insert command in sql
SQL
0 vote160 views1 answer
Commit transaction sql
SQL
0 vote159 views2 answers
Sqlalchemy core in clause
SQL
0 vote173 views1 answer
Open postgresql.conf in centos
SQL
104 votes1.1K views2 answers
Like in mysql
SQL