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

58 votes536 views6 answers
Create new user in postgres
SQL
1 vote214 views1 answer
How to run sql script
SQL
0 vote292 views1 answer
How to join result table in mysql
SQL
0 vote278 views3 answers
Mysql keyword search
SQL
0 vote232 views1 answer
How to set field to null in sql
SQL
0 vote297 views1 answer
Doctors appointment
SQL
-1 vote262 views3 answers
Check table exist postgresql
SQL
7 votes259 views3 answers
How to check table name in current database sql
SQL
1 vote254 views3 answers
String to int mysql
SQL
2 votes272 views1 answer
Sql ends with string
SQL