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 vote182 views1 answer
Edit shchima table in sql
SQL
3 votes158 views2 answers
Mysql config user password
SQL
-1 vote152 views2 answers
How to display top 50 rows?
SQL
10 votes177 views2 answers
Sql pagination offset
SQL
0 vote211 views1 answer
Mysql could not fetch tables
SQL
2 votes175 views1 answer
Sql update \
SQL
0 vote149 views3 answers
Postgresql grant alter table to user
SQL
0 vote155 views2 answers
Sql select inside select
SQL
0 vote149 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
0 vote169 views1 answer
Count number of entires by months sql
SQL