Reputation: 43
For example
SELECT product_c, price, price 'New Price'
I wanted to increase the price by 20%
Upvotes: 0
Views: 368
Reputation: 5838
SELECT product_c, price, (price* 1.20) as new_price FROM Table;
Upvotes: 2