Tutorial :Calculate VAT in SQL [closed]



Question:

How do you write a SQL query to calculate the VAT and then add it to Total?


Solution:1

Surely homework.

However, let us know what you've tried. In general, you're supposed to make an effort first before people on SO will help you.

What does your table look like? How is the total calculated? What query returns the total? What do you need to do to the total to add tge VAT?

Paul


Solution:2

the calculation very easy for the UP let the 1st steps as down

01) the Vale are as whatever 100 the vat amt has been fixed by the goverment suppose 15% the the formula apply sum(value*15) the total cost of the commidities add to the 15%


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »