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

2 votes419 views1 answer
Sql compare strings
SQL
0 vote403 views1 answer
Sql int vs integer
SQL
13 votes377 views1 answer
Sql join 3 tables on id
SQL
2 votes361 views1 answer
Oracle kill session by sql_id
SQL
0 vote367 views1 answer
Postgres select from values
SQL
1 vote379 views1 answer
Group_concat order by
SQL
15 votes352 views6 answers
Drop foreign key mysql
SQL
0 vote366 views1 answer
Oracle current session details
SQL
60 votes591 views6 answers
Add column in sql
SQL
1 vote329 views1 answer
Reutrn string after character sql
SQL