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 vote347 views1 answer
Sql server udf performance
SQL
0 vote334 views1 answer
Declare date variable sql
SQL
22 votes336 views4 answers
Mysql reset auto increment id
SQL
0 vote359 views1 answer
Mysql where in maintain order
SQL
37 votes340 views3 answers
Duplicate records in sql
SQL
5 votes405 views3 answers
Create function in postgresql
SQL
3 votes377 views1 answer
Laravel paginate raw sql
SQL
0 vote344 views1 answer
Select multiple row from primary key sql
SQL
0 vote333 views1 answer
How to set all the min and sec data to zero in sql server
SQL
18 votes344 views6 answers
Laravel form validation
SQL