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

1 vote256 views1 answer
Find difference in dates sql
SQL
0 vote344 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
3 votes242 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote267 views1 answer
SELECT statement to find the specific cell in database table
SQL
11 votes317 views2 answers
Import mysql dump command line windows
SQL
3 votes247 views3 answers
How to set up an auto incrementing id db browser
SQL
0 vote258 views1 answer
Mysql utc timestamp
SQL
0 vote243 views1 answer
Declarative base sqlalchemy
SQL
1 vote265 views1 answer
Convert varchar to int in sqlite
SQL
0 vote245 views1 answer
Mssql describe stored procedure sqlcmd
SQL