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

2 votes283 views1 answer
Oracle run_duration average
SQL
2 votes282 views1 answer
How to show the whole table in sql
SQL
4 votes275 views3 answers
How to describe a table in sqlite3
SQL
0 vote260 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote292 views1 answer
Oracle sql alter view add column
SQL
1 vote259 views10 answers
Stack overflow
SQL
0 vote267 views1 answer
FIND ABOVE AVERAGE SALARY EARNER IN SQL
SQL
3 votes278 views1 answer
Force using index plsql
SQL
7 votes274 views1 answer
Safe update mysql
SQL
0 vote280 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL