oncik oncik - 3 months ago 35
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
SELECT product_c, price, (price* 1.20) as new_price FROM Table;