AMOUNT TAX% TAXAMOUNT -------------------------------------- 1000 2 20 2000 5 100 3000 5 150 4000 2 80
TAX % ON AMOUNT TAX AMOUNT -------------------------------------- 2 5000 100 5 5000 250
select Tax%, SUM(AMOUNT), SUM(TAXAMOUNT) from Accounts group by Tax% order by Tax%
ORDER BY Tax
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)