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 vote138 views1 answer
Postgres data location
SQL
0 vote146 views1 answer
Sum values by month mariadb
SQL
0 vote143 views2 answers
Mysql to python pandas
SQL
0 vote144 views2 answers
Postgres show current role
SQL
1 vote145 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote142 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
1 vote156 views1 answer
Postgres left join
SQL
0 vote151 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote193 views1 answer
Sqlalchemy query return only n results
SQL
5 votes139 views3 answers
Sql max value in column
SQL