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 vote101 views1 answer
Json_remove mysql
SQL
3 votes106 views5 answers
No module named 'MySQLdb'
SQL
3 votes109 views1 answer
Locate sql server
SQL
6 votes98 views2 answers
Mysql version check cmd
SQL
0 vote139 views1 answer
Multiple like values for single column postgres
SQL
0 vote94 views1 answer
Metada in sql
SQL
0 vote145 views1 answer
Kimball data warehouse sql calendar
SQL
1 vote106 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote96 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
22 votes108 views4 answers
Mysql date_format
SQL