Tasneem
Last answered:

12 Dec 2022

 Posted on:

10 Dec 2022
0

why is it (10,2) in particular ?

in SQL / User-defined functions in MySQL

why in decimal he but a 10,2

1 answers ( 0 marked as helpful)
Tsvetelin Tsonkov
Instructor
Posted on:

12 Dec 2022
0

Hi Tasneem!
Thanks for reaching out.

DECIMAL(10,2) means you can have a decimal number with a maximal total precision of 10 digits. Two (2) of them after the decimal point and eight (8) before. It is not so important why this is used. It is important to know how it works. The idea is to have option for bigger salaries.

Hope this helps.
Best,
Tsvetelin

Submit an answer

related questions

Marcus Wern Han Leong
2
16
Why did you not do not null, primary key and auto increment for customer id in the solution?
Abdelrahman Samy
0
14
Resolved: why this code not valid
E E
0
10
Resolved: Why is the highlighted practice not considered a best practice?
Pawee Chiranothai
0
6
Why does drawing data from dept_manager_dup table get different results?
Saeed Ehsanfar
0
6
Need clarification on why using e.emp_no < 10011 in the WHERE clause
Sachintha Adikari
2
6
Why can't we just use IN?
Marcus Wern Han Leong
0
6
Why can't I do this code instead?
Mayank Mittal
0
6
why distinct in this case doesn't work same as group by
Angeline
0
6
Resolved: Why only eleven employees?
Mohamed AbdulHalim
0
6
Resolved: Why don't aliases work?
Lifang Kuo
0
6
Why is d.dept_no and dm.dept_no different in the first place?
Abdul Rehman
0
6
Resolved: Why you are using different query editor for like new query for table creation of sales then new que