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 vote163 views1 answer
Oracle create index if not exists
SQL
2 votes146 views1 answer
Drop table if exists in postgres
SQL
10 votes151 views4 answers
Sql pagination
SQL
0 vote140 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote108 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote185 views1 answer
Create table with timestamp mysql youtube
SQL
0 vote165 views1 answer
Plpgsql if statement
SQL
0 vote159 views1 answer
Mysql coonect sample code
SQL
0 vote139 views1 answer
Pgadmin see indexes
SQL
2 votes185 views1 answer
Search query in mysql
SQL