Need help with sql update query.

Posted by via-point on Stack Overflow See other posts from Stack Overflow or by via-point
Published on 2010-03-12T03:05:02Z Indexed on 2010/03/12 3:07 UTC
Read the original article Hit count: 148

Filed under:
|

I have table 'products' and I need to update 'price' field by 20% if product 'type' field is "imported".
How do I read and update field at the same time in my UPDATE query?

© Stack Overflow or respective owner

Related posts about sql

Related posts about oracle10g