oncik oncik - 1 year ago 127
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;
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download