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 vote177 views1 answer
Mysql a from on this page has
SQL
0 vote190 views1 answer
Sql select lowest value row
SQL
10 votes179 views4 answers
SELECT FROM WHERE
SQL
1 vote183 views1 answer
Sqlserver create table from select
SQL
2 votes233 views1 answer
How to check grants on a package in oracle
SQL
1 vote232 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
0 vote167 views1 answer
Sql select most frequent value in group
SQL
0 vote201 views3 answers
Sql select statements
SQL
0 vote139 views1 answer
Mariadb list tables
SQL
1 vote165 views1 answer
Python escape mysql
SQL