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 vote143 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote138 views1 answer
Mysql delete from where like
SQL
0 vote130 views1 answer
Sql cheetsheet
SQL
0 vote129 views1 answer
Implicit inner join table alias with id values
SQL
5 votes82 views1 answer
Mongodb vs
SQL
0 vote183 views1 answer
Postgres rename database
SQL
1 vote139 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote139 views2 answers
Jsonb
SQL
0 vote133 views1 answer
Sql get year from datetime field
SQL
1 vote125 views2 answers
Mysql: command not found
SQL