Question: Database System Chapter 7, How to round the result to 2 decimals P29, subtotal, P30, P31 TotalPurchases amount to 2 decimals ex:443.999 would be 444.00

Database System Chapter 7, How to round the result to 2 decimals P29, subtotal, P30, P31 TotalPurchases amount to 2 decimals ex:443.999 would be 444.00 P32 TotalPurchases, Average Purchase Amount

Please provide complete and detailled answer, for mysql

This is in my textbook, which is Database System Management 12 edition. chapter 7 , p=problem 29, problem 30, problem 31, and problem 32.

I want the result to be shown rounded to decimal. I believe you have the answer to these questions in your system, but I want the result to be rouded to 2 decimals .

Thank you

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!