oncik oncik - 1 month ago 19
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;