Question

assume that you have a new column called itempricetax after tax added to the item table this column will store the price of the item after tax. Write a sql statement to update all the values of this column. sales tax is 6.25%.

Answer 1

We can use an alter statement to insert a new column to a existing table and then to update the values of that column update statement can be used. According to the question, itempricetax is a new column into existing table item . We can assume that there is a price column that contains price of respective item then we can use the update statement like

Update item set itempricetax = (0.0625*price)+ price ;

A where clause is often given in update statement if we want to change particular row but since in this case we want to update all rows so where clause is not used. The above statement will add sales tax of 6.25% to the price of the items.