oncik oncik - 10 months ago 99
SQL Question

How to increase price with percentage?

For example


SELECT product_c, price, price 'New Price'


I wanted to increase the price by 20%

Dez Dez
Answer Source
SELECT product_c, price, (price* 1.20) as new_price FROM Table;