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
8
Resolved: why this code not valid
Angeline
0
6
Resolved: Why only eleven employees?
Saeed Ehsanfar
0
6
Need clarification on why using e.emp_no < 10011 in the WHERE clause
E E
0
6
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?
Abdul Rehman
0
6
Resolved: Why you are using different query editor for like new query for table creation of sales then new que
Mayank Mittal
0
6
why distinct in this case doesn't work same as group by