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 vote246 views1 answer
Database schema for mcqs type exam in sql
SQL
3 votes214 views4 answers
Mysql decimal
SQL
11 votes228 views2 answers
Mysql set safe mode off
SQL
0 vote220 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote206 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
0 vote218 views1 answer
How to input data as id in database sql c#
SQL
7 votes237 views1 answer
Sql pagination oracle
SQL
0 vote269 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote212 views1 answer
Optimize sql query
SQL
-1 vote227 views4 answers
Restart mysql server ubuntu
SQL