update price plus 20 porcent where sql

YOUNESS EL FATOUAKY answered on October 5, 2022 Popularity 1/10 Helpfulness 1/10

answer update price plus 20 porcent where sql

Comment

update your_table
set price = price + (price * 20.0 / 100.0)
where id = (some condition)

Popularity 1/10 Helpfulness 1/10 Language sql

Tags: price sql where

Link to this answer
Share Copy Link

Contributed on Oct 05 2022

YOUNESS EL FATOUAKY

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Oops, You will need to install Grepper and log-in to perform this action.