oncik
oncik

Reputation: 43

How to increase price with percentage?

For example

SELECT product_c, price, price 'New Price'

I wanted to increase the price by 20%

Upvotes: 0

Views: 368

Answers (1)

Dez
Dez

Reputation: 5838

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

Upvotes: 2

Related Questions