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 vote205 views1 answer
Group by max date
SQL
36 votes254 views6 answers
Change column data type sql
SQL
0 vote184 views1 answer
Create or replace view postgress
SQL
5 votes194 views1 answer
Oracle sysdate
SQL
0 vote186 views2 answers
How to find max and min salary in sql
SQL
1 vote199 views1 answer
Check if mysql is installed
SQL
2 votes228 views1 answer
Get the mysql table columns data type mysql
SQL
6 votes210 views4 answers
Mysql group by date
SQL
24 votes187 views2 answers
Alter table delete column
SQL
0 vote204 views1 answer
How do you insert boolean to postgresql
SQL